Forums

Too much queries needed for loading the page. (3 posts)

  1. OnlyforMen
    Member
    Posted 6 years ago #

    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 :)

  2. lunabyte
    Member
    Posted 6 years ago #

    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.

  3. OnlyforMen
    Member
    Posted 6 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags