Last updated on August 23rd, 2014 at 07:49 am
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
[code lang=”sql”]
DELETE FROM `wp_options` WHERE `option_name` LIKE (‘%\_transient\_%’)
[/code]