WooCommerce has a built-in feature to get the customers’ default location using geolocation. The geolocation feature in WooCommerce uses the MaxMind API. Currently, if you are using this feature on your WooCommerce store you could have 20-40k transients related to it.
Transients are used for storing cached temporary data that is stored in the options database table. WooCommerce will store the geolocation transients in the site’s options database table for one week.
You can easily delete any existing geolocation transients from WooCommerce by using phpMyAdmin to search for the following option names:
You could also use a plugin like WP Data Access then you could explore the options database table and look for all of the related transient options to delete those.
WordPress core does have a cron event called:
That cron event will run daily to automatically delete all expired transients. WooCommerce aslo has a built-in tool from wp-admin;
WooCommerce >Status > Tools
Reducing transients stored in the site's database as well as making sure that expired transients are deleted will help keep your site performing well and will help with wp-admin load times.
For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.