WordPress.org

1. cou
   Member
   Posted 2 years ago #

   Hi,

   I am having massive problems with my site - it's painfully slow. Wordpress's search function takes over 200 seconds to complete, so something is badly wrong. Is there a plugin which can show me all the queries Wordpress runs on any given page, perhaps outputting it "hidden" in the comments (<!--)?

   Failing that, if anyone can give me an example of the SQL used for a search query, with all the necessary joins etc, so I can run it on PHPMyAdmin, that would be terrific

   Thanks

   Will

2. cou
   Member
   Posted 2 years ago #

   Found a plugin here

   http://vapourtrails.ca/wp-plugins

   It's superb

3. drmike
   Member
   Posted 2 years ago #

   Check your theme's footer.php file as it may already be in there, just commented out.

   Example:

   http://mu.wordpress.org/forums/topic.php?id=2686

   Here's also a thread about listing what queries are occuring:

   http://wordpress.org/support/topic/83525

   Things to try:

   1) Check your webserver's error logs to see if you're getting anything in there.

   2) Run optimize on your database.

   3) Make sure the box that you sit on is not overtaxed.

   4) Turn off all of your plugins and try again. if it works better, then turn on your plugins one by run and test to see where the issue is.

   May not exactly answer your question but it'll get you started.

   Hope this helps,
   -drmike

Topic Closed

This topic has been closed to new replies.