Database queries on pages

  • Resolved Yworld

    (@yworld)


    4 years, 2 months ago

    Hello.
    There are many database queries on each page, they take a long time.
    Can this be optimized?
    Verified by plugin Query Monitor.
    For large sites, this is important when the plugin is slower than the core. Especially in the categories on the homepage …

    • This topic was modified 4 years, 2 months ago by Yworld.
    • This topic was modified 4 years, 2 months ago by Yworld.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author arnaudbroes

    (@arnaudbroes)

    Hey @yworld,

    Can you give an example (or screenshot) of these queries? We are aware that Query Monitor is flagging some of our queries as “slow” even though most of them are pretty fast.

    – Arnaud

    Thread Starter Yworld

    (@yworld)

    @arnaudbroes
    homepage https://prnt.sc/w8c95s
    article https://prnt.sc/w8cahu
    duplicate requests https://prnt.sc/w8cbgy
    This is a test site and several posts and categories.

    • This reply was modified 4 years, 2 months ago by Yworld.
    • This reply was modified 4 years, 2 months ago by Yworld.
    Plugin Author arnaudbroes

    (@arnaudbroes)

    Hey @yworld,

    Those are queries we need for various features and can’t eliminate or optimize. But if you check closely, you should see that they are lightning fast.

    For example, I added up all the execution times that are listed in the screenshot of the homepage and got to a total of 0,0219. That means it only took around 22 milliseconds (or 0,022 seconds) to complete those queries. That shouldn’t affect the performance of your site at all.

    – Arnaud

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database queries on pages’ is closed to new replies.