Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I have been doing some cleaning up in the database of one of my WordPress installs, and I noticed that the wp_options table was about 2.1mb, and had 1200 rows. I've gotten it down to around 800 rows, and 1.2mb. However, there are a bunch of transients.

Should I remove these? I know they don't autoload, so it probably isn't causing strain on the database.

Most of the transients have formatting like the following:

_site_transient_browser_03df11ec4fda7630a5...
_site_transient_browser_065e09a1287aadfb4d...
_site_transient_timeout_browser_03df11ec4f...
_site_transient_timeout_browser_065e09a128...
_transient_feed_1a5f760f2e2b48827d4974a608...
_transient_feed_f8e8c12cc5c787789728d7481a...
_transient_feed_mod_e6460a14e5784b3ee64f91...
_transient_timeout_feed_1a5f760f2e2b48827d...

So, is it worth taking the time to remove these?

Thanks for reading! Any thoughts are appreciated.

share|improve this question
add comment

1 Answer

up vote 4 down vote accepted

This is not an amount that is likely to cause performance issues. However if you are concerned about leftover transients it is worth looking into if any code you are using is consistently "leaking" them (creating transients that are never removed).

See Are transients garbage collected? for relevant discussion and some code snippets.

share|improve this answer
    
Thanks for the reply! That thread looks extremely informative as well. Is there any harm in removing the transients? –  Ryan May 4 '12 at 18:33
2  
@Ryan in plain removing them - no, although there might be no effect either because as Otto notes in his answer on that question you need to run optimize to actually get table reshuffled after removal. As per my answer - it's more important to pro-actively not have them spawned in large quantities than remove them reactively. –  Rarst May 4 '12 at 18:37
    
Thanks again! I will see if I can find what's causing these, but there isn't an overwhelming amount. I read other people having 100,000's of transients in the wp_options, and while that seems like a more serious problem, having a couple hundred rows of transients doesn't seem like anything to overanalyze... Which is exactly what I'm doing, haha. –  Ryan May 4 '12 at 18:39
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.