Delete expired _transient in wordpress to optimize the database

If you separate your database to another server, and if the wp_options table is going bigger to 2MB, then it will slow down your query time, because WordPress like to query all the data from the table wp_options always.

You have to make the table smaller size to speed up the query.

I always clean up those useless _transient from the database, it could save you mostly 1MB

DELETE FROM `wp_options` WHERE `option_name` LIKE ('%\_transient\_%')

Tags:

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.