Heavy Queries

  • Resolved massimod

    (@massimod)


    6 years, 9 months ago

    Hello.

    After installing this plugin everything was very slow.

    So i see my home page execs 136 queries without the plugin but execs 177 with the plugin enabled (and a widget of top 10).

    Removing the widget of top10 from my home, the queries go down to 142.

    Finally my dashboard takes twice as long to load when top10 plugin is enabled.

    Why all that load ? Am i doing something wrong ?

    Thanks

    • This topic was modified 6 years, 9 months ago by massimod.
    • This topic was modified 6 years, 9 months ago by massimod.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Ajay

    (@ajay)

    Is this a recent install? And, can you check the execution time in total of the queries?

    I suggest enabling the inbuilt cache of Top 10 as this limits the queries massively after the first load. It uses the transients system which caches the widget hourly.

    Many of the queries relate to fetching the data of the post that is being processed in the loop.

    Thread Starter massimod

    (@massimod)

    Yes a totally new install in a website with some 4000 blog posts.

    I will try all the above and update here.

    Thank you

    • This reply was modified 6 years, 9 months ago by massimod.
    Plugin Author Ajay

    (@ajay)

    Thank you. There is potentially another option to do a custom lookup with WP_Query as shown in this example: https://gist.github.com/ajaydsouza/c8defd4b46e53240e376

    You will need to write up the HTML to generate the necessary output style.

    Thread Starter massimod

    (@massimod)

    Using the caching seems to make things much better, i set mine to 86400 (a day).

    I will keep an eye and see how it goes.

    Thank you !

    Plugin Author Ajay

    (@ajay)

    Thank you. Let me know how it goes. Am keen to see how I can optimise the queries further, but not completely sure on what can be done.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Heavy Queries’ is closed to new replies.