Too much queries needed for loading the page.

  • My weblog is way slow lately and I tried a few solutions to boost up the performance.

    I’ve tried a few solutions:

    1. I removed all counters in order to boost up performance
    2. I removed all images that were hotlinked, I’m now hosting them myself
    3. I deactivated all WordPress plugins that weren’t that necessary.
    4. I optimized and repaired the database of WordPress, and deleted unnecessary tables.

    And I came to the conclusion that the SQL database is the problem, I added a bit of php code to see how much queries where needed to display the page and how long it took to perform those queries.

    The results:

    Displaying 30 posts, without disabling some plugins: 120 queries or something like that.
    Displaying 30 posts and only using the necessary tables: 103 queries. 22.160 seconds. (I’m currently running this mode)
    Displaying 10 posts: 43 queries. 1.201 seconds.

    Or in other words: Way too much! It should be around 25-40 queries (afaik)

    What could it be? And how can I drastically lower the amount of queries?

    Thanks in anticipation ??

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

  • Sounds like the server you’re on is a little over-worked. :-\

    Try disabling all your plugins, then readding them one by one, and see if one is causing the problem.

    That seems a little high in the number of queries though.

    Thread Starter onlyformen

    (@onlyformen)

    Thanks lunabyte, I’ve found the problem:

    Going from 13 to 103 queries thanks to:

    FeedWordPress | 0.98 | simple and flexible Atom/RSS syndication for WordPress | By Charles Johnson.

    I’ve already left a comment at this website to inform him about the massive increase of queries thanks to the plugin.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Too much queries needed for loading the page.’ is closed to new replies.

Tags