Duplicate SQL Queries : Code optimization

  • Resolved fabricelaborie

    (@fabricelaborie)


    5 years, 10 months ago

    Hello,
    I was trying to find some performance bottlenecks on my site.

    With the help of the plugin “Query Monitor”, I noticed that some SQL queries being called up to 6 times when I try to display one particular event ( ex: https://hejazultra.org/event/jim2021/) I’m seeing 3 duplicate queries: https://prnt.sc/snehjj
    2 are from this plugin. (the 3rd one is from TEC Calendar Pro … I can open a ticket there as well if needed)

    We are a small running club. Our website has very little load especially at the moment, and I suppose mysql will do some DB caching, so the duplicate queries do not seem to be a major issue at this point of time, but it might be for larger sites, so it should be investigated and code turned for performance .

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • jeremy80

    (@jeremy80)

    5 years, 10 months ago

    Hi @fabricelaborie,

    Thank you for letting us know about these unexpected queries.

    Did you notice your website was getting slower after updating to the latest version of Event Tickets (ET 4.12.1)?

    Do you only have these duplicate queries when displaying your event, or also when performing other actions like getting a ticket?

    Do you have the same issue when all plugins are deactivated except for TEC and ET?

    Thanks!

Viewing 1 replies (of 1 total)

The topic ‘Duplicate SQL Queries : Code optimization’ is closed to new replies.