WordPress admin section’s are running 2500 queries!

  • I’ve been experiencing problems within the ‘admin’ section of WordPress, specifically pertaining to speed. It feels like whenever I’m updating a page, upon pressing update, it takes about 1-2 minutes to ‘save’. This slowness of speed is also observed on the Permalink Settings page which is running over 2500 queries!

    I have a lot of pages with picture galleries (some [wordpress] galleries have 200 pictures) and it seems like it’s grabbing every single entry (page, post, or picture)! Why is it doing this and how can I prevent this from happening? It’s slowing down the admin section tremendously and I can’t figure out how to prevent these erroneous queries from occurring.

    I copied the links to a texteditor and uploaded them here:
    https://www.jaketoolson.com/misc/queries.rtf

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

  • Have you tried:

    – deactivating all plugins to see if this resolves the problem? If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – switching to the default theme to rule out any theme-specific problems?

    Thread Starter jaketone

    (@jaketone)

    Yes, even after deactivating each plugin and reseting the theme to ‘default’, the same queries are still run.

    Thread Starter jaketone

    (@jaketone)

    My options table, i’ve noticed, if i “optimize” the table, saving a page runs quickly one time. After that save, the options table’s overhead is 5 MiB! I try to save a page and it goes slow and hangs. If I optimize the table again, it goes fast one time.

    Was that with all plugins deactivated and using the default theme?

    Thread Starter jaketone

    (@jaketone)

    Yes, all plugins were disabled and the default theme was run.

    Thread Starter jaketone

    (@jaketone)

    This only happens on “pages” and not posts… I just can’t get to the bottom of this either. Any help would be appreciated.

    I think I might have a similar problem and I’m looking for the answer here as well. I have 1350 pages and when I try to add/edit a page, I get this error [Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 40 bytes) in /home/admin/public_html/manausa.com/tallahassee-mls/wp-includes/meta.php on line 197]

    I’ve read all the forum stuff recommending I change php.ini or .htaccess, but I’m limited by Hostgator to 64MB. I’m wondering what is causing the problem (yes deactivated plugins, etc). I think it only happens when it tries to load the 1350 pages in the wp-admin. They are small and simple pages, but that is I think it lies.

    Any clues?

    @joemanausa: Completely different issue. Please post a new topic.

    @jaketone: What custom permalink structure are you using? How many Pages (as opposed to Posts) do you have?

    @joemanusa this is an issue with the cache updating that is done in meta.php. I’ve added a solution to /support/topic/382253 which may suit your situation.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘WordPress admin section’s are running 2500 queries!’ is closed to new replies.