Facebook Plugin filling up wp_options database table

The Facebook plugin for WordPress uses the WordPress Transient API to cache values in your site’s configured WordPress persistent cache or fallback to the options table if you have not properly setup a WordPress persistent cache.

You may find the WordPress Object Cache documentation useful.

If your site uses the WordPress comments box plugin and your theme uses the get_comments_number() function to display the number of comments attached to a post then the Facebook plugin for WordPress needs to send a request to Facebook servers asking for the current number of approved comments associated with the post. Once the plugin receives the result of the comments count request from Facebook servers the number is recorded into the WordPress cache system to quickly serve the next request. If 100 people visit the page in five minutes you might see 1 request to Facebook servers for a fresh total number of approved comments followed by 99 requests to the WordPress caching system to retrieve the latest version. Requesting a comment count from cache is typically faster than a roundtrip request to Facebook servers.

The transient entries in your options table are likely a result of the transient API not finding a better WordPress persistent cache option configured on your server. You can speed up your pages and reduce MySQL access by configuring your WordPress persistent cache.

Thanks. I’m using WP Super Cache. There are times when caching is turned off for site development, but generally it’s on all the time.

I’m not at all sure how to accomplish what you say above or what is needed.

In wp-config.php, it has:
define(‘WP_CACHE’, true); //Added by WP-Cache Manager

Can you provide guidance?

Thanks
Dave

Also, shouldn’t the rows in wp_options expire at some point and get deleted?

It doesn’t appear that that is happening…

Is there a setting so the transients get cleaned out of the database? Or should this happen automatically? How often?

The Facebook plugin for WordPress requests a comment count expiration of 15 minutes through the WordPress transient API. WordPress manages the storage and expiration abstraction across various server configs.

Hi,

is there any solution about this “problem”?

My database is getting fuller and fuller and the transients don′t erase. Why?

Can someone help me please?

Thanks ??

Sebi