WordPress.org

Support

Support » Plugins and Hacks » [Plugin: Twitter Tools] Made server very slow

[Plugin: Twitter Tools] Made server very slow

Viewing 5 replies - 1 through 5 (of 5 total)
  • I’d agree that the plugin isn’t very well thought out. I’m now considering removing it from the wordpress mu system I maintain at my university. The problem seems to be that even for blogs which aren’t using it, the default option to display the sidebar causes links to js and css files. These take seconds to load for some reason.
    Anyone using wordpress mu should avoid this plugin. Likewise busy single wordpress sites.

    I was having the same issue, but it turned out that it’s because twitter tools keeps a DB table of all tweets you’ve had. Problem is, there seems to be a bug that’s causing it to grab the same tweets more than once. My table grew to over 80k rows (I’ve tweeted less than 1000).

    Duplicated the table, then emptied out the original, and things are back to normal. It still seems to be downloading them multiple times… so until that’s fixed (either a bug in the twitter api, or twitter tools), I’m just going to empty the table every couple weeks.

    Might check it out. Table is called <wordpress-prefix>_ak_twitter (so, with a default install, it would be wp_ak_twitter.

    That, combined with the SQL query to grab the tweets from the DB, made it really quite slow with 80k rows.

    Any good alternatives to Twitter Tools you’d recommend?

    Figured out (with the help of google), that if you have access to your mysql database that wordpress resides on, you can do this:

    delete from wp_ak_twitter using wp_ak_twitter,wp_ak_twitter as vtable where vtable.id > wp_ak_twitter.id and vtable.tw_id = wp_ak_twitter.tw_id;

    That will delete all the duplicate records from the table. You’ll want to do an optimize table after the fact.

    This took my twitter tools table from 85693 rows (10.5MB) to 470 rows (59kb).

    Obviously twitter tools needs to implement a check before inserting rows that makes sure the twitter id doesn’t already exist… but for now, this works.

    Please make sure to do a mysqldump before attempting this. I don’t want to be liable for you losing your data.

    Good luck!

    I became to be suspecting this plugin makes my WordPress slow, and checked my DB. But the duplicated records in MySQL seems not happening on my instance now, that is, (wp_)ak_twitter table has one record for each article already tweeted. So it must be fixed on the recent version (maybe 2.1? changelog has one related DB bug fix).

    Besides this, I am seeing that the Twitter Tools plugin’s Javascript and CSS files (aktt_js and aktt_css) are called a lot on web server access log. But not sure yet.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: Twitter Tools] Made server very slow’ is closed to new replies.