All Low add-ons are now owned by EEHarbor. Read the blog post.

Support archive

Long queries

Abhilekha Nirwan 4 Jul 2017 13:27 question, complete

Long queries are queued up at my server. I can see some of the queries taking 70-90 seconds, that is obviously too slow. How can I optimize those queries? The number of total records are more than 100K. Can you share some idea/solution for this? I can also see a lot of sub queries being used, can we change that structure too somehow?

Replies

  1. Low 5 Jul 2017 07:04

    What are we talking here? Which version of EE? Which Low add-on and which version?

    In general, there's probably not a lot you can do about the structure of the queries that ExpressionEngine and its add-ons generate. It's a matter of optimising your templates and then, if it's still too slow, apply some caching.

  2. Abhilekha Nirwan 12 Jul 2017 10:59

    Thanks for the reply Low. I figured the issue, it was not Low search though it was Filter addon that was customized and hanging the server.