Title: Slow Database Queries
Last modified: August 30, 2016

---

# Slow Database Queries

 *  Resolved [meetatthebarre](https://wordpress.org/support/users/meetatthebarre/)
 * (@meetatthebarre)
 * [11 years ago](https://wordpress.org/support/topic/slow-database-queries/)
 * Hello, the admin side of my site has been running slow so I installed your plugin
   to help. The only thing that was running slow, was wp_load_alloptions()
 * SELECT option_name, option_value
    FROM wp_4ncwr0m4x8_options WHERE autoload =‘
   yes’
 * I am very new to this. Could you explain to me how I can fix this or what it 
   is trying to tell me? Thank you in advance.
 * My site is running just fine
    [http://meetat-thebarre.com](http://meetat-thebarre.com)
 * [https://wordpress.org/plugins/query-monitor/](https://wordpress.org/plugins/query-monitor/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [John Blackbourn](https://wordpress.org/support/users/johnbillion/)
 * (@johnbillion)
 * WordPress Core Developer
 * [11 years ago](https://wordpress.org/support/topic/slow-database-queries/#post-6318573)
 * This potentially means that your options table (`wp_4ncwr0m4x8_options`) has 
   gotten populated with so many options that it’s causing a slowdown.
 * There’s no single answer to fixing this. It can be caused by plugins which leave
   lots of data in that table after you’ve uninstalled them, or it could be caused
   by a plugin which is storing massive amounts of data in transients, which are
   also stored in the options table by default.
 * One thing you could try is running the “Repair and Optimize Database” function
   in WordPress. [Instructions can be found here](https://www.maketecheasier.com/fix-corrupted-wordpress-database-2/).
 * Another thing you can try is installing and running the [P3 Profiler plugin](https://wordpress.org/plugins/p3-profiler/),
   which can point out plugins which are causing your site to slow down, although
   off the top of my head I’m not sure if it has a function for testing the admin
   area.
 *  Thread Starter [meetatthebarre](https://wordpress.org/support/users/meetatthebarre/)
 * (@meetatthebarre)
 * [11 years ago](https://wordpress.org/support/topic/slow-database-queries/#post-6318575)
 * I appreciate it. I tried deactivating my plugins and it doesn’t seem to be helping.
 *  [uday.dahale](https://wordpress.org/support/users/udaydahale-1/)
 * (@udaydahale-1)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/slow-database-queries/#post-6318822)
 * I want optimzie below query…
 * SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’
 * Please help me….
 * regards,
    UD

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Slow Database Queries’ is closed to new replies.

 * ![](https://ps.w.org/query-monitor/assets/icon.svg?rev=2994095)
 * [Query Monitor](https://wordpress.org/plugins/query-monitor/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/query-monitor/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/query-monitor/)
 * [Active Topics](https://wordpress.org/support/plugin/query-monitor/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/query-monitor/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/query-monitor/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [uday.dahale](https://wordpress.org/support/users/udaydahale-1/)
 * Last activity: [10 years, 5 months ago](https://wordpress.org/support/topic/slow-database-queries/#post-6318822)
 * Status: resolved