Topic

Hi,

This is regarding my site: http://www.technologyvista.com
Just after installing this plugin, my hosting provider locked down the site because of generation of slow queries. the queries are of the following nature:
[blockquote][blockquote]{content}[/blockquote]Executed 169 min ago for 1 sec on Database –> techn666_wpcom.
SELECT COUNT[*] as records, SUM[LENGTH[m.meta_id] + LENGTH[m.post_id] + LENGTH[m.meta_key] + LENGTH[m.meta_value]] as size FROM wp_postmeta m WHERE m.post_id IN [SELECT p.ID FROM wp_posts p WHERE p.post_status = ‘spam
Executed 78 min ago for 1 sec on Database –> techn666_wpcom.
SELECT COUNT[*] as records, SUM[LENGTH[m.meta_id] + LENGTH[m.post_id] + LENGTH[m.meta_key] + LENGTH[m.meta_value]] as size FROM wp_postmeta m WHERE m.post_id IN [SELECT p.ID FROM wp_posts p WHERE p.post_status = ‘auto-draft’ and p.post_type = ‘rssmi_feed
[/blockquote]
This is for sure that the queries are being generated from some database cleaning agent. I wanted to know if these queries are pertaining to your plugin? If yes, how do you address this inefficient queries?

Regards
Amitava

Replies

Hi,

yes, these are queries from my plugin, but they are not slow queries, since they perform only count and sum over the data that is indexed, and there are no joins even in there. Every plugin I make I always test SQL queries that might be causing problems, and the same is done with this plugin, and no such queries are found. Also, plugin is used on large number of websites and no one has reported anything similar to this.

And the log you posted says that the query was executed for 1 second, and if that is not rounding up, it points that your server is very slow or has some other performance issue. On most hosting servers, these queries typically run in under 0.1 second.

Regards,
Milan