Support » Plugin: The Events Calendar » too many queries

  • I understand that this is a powerful plugin, but I can only use it with an even more powerful host. Plugin Profiler shows more than 40 queries in any given page in the backend and in the calendar frontend view that number goes up to more than 50! My loading times are around 10+ seconds. Considering that my core only has around 17 queries, this plugin is doing much more than it really needs.

    • This topic was modified 5 months, 2 weeks ago by  paulovsky.
Viewing 1 replies (of 1 total)
  • Plugin Author Barry

    (@barryhughes-1)

    We appreciate the review, @paulovsky – though of course it’s disappointing to see a low rating this is a good opportunity for us to learn more.

    With regards to performance, we’re continually looking at ways to improve and a large percentage of our releases make incremental improvements in this regard – tightening up queries and improving caching. There is certainly room for us to do more but we do also need to proceed cautiously in order to avoid breakages and to limit backwards incompatible changes wherever possible.

    Plugin Profiler shows more than 40 queries in any given page in the backend and in the calendar frontend view that number goes up to more than 50!

    This does surprise me somewhat.

    There will certainly be a small number of queries relating to our plugin on all (or almost all) admin screens and some of these happen automatically because of the way WordPress works, others we’ve deliberately added to achieve certain goals.

    More than 40 on screens that are unrelated to our plugin (such as the user admin screens) though sounds incredibly high and I don’t see the same thing. Would you be down to create a support topic sharing some notes and perhaps screengrabs of the plugin profiler output, with a note of the screens you are obtaining that data from?

    My loading times are around 10+ seconds. Considering that my core only has around 17 queries, this plugin is doing much more than it really needs.

    Similarly, I’d love to have a better idea as to how many events you have and how many posts in total. If that’s information you can share, that would be awesome.

    As a sidenote about the number of queries, it is not necessarily the case that fewer queries equals faster. One way or another we need to build out views which organize and present event data (sometimes lots of event data) in certain ways and there are occasions where many but more atomic queries make more sense than fewer but larger and slower queries.

    In any case, we do appreciate you taking the time to share this review and if there is more information you can provide, we’d love to review it.

    Thanks again!

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this review.