I am looking to optimise my website.

Searching for orders through the rest api is too slow. It's taking around 23 seconds for the query execution here:


On researching further, I found out that:


This is being called over 400 times for certain search queries.

Any thoughts on how to optimise it, or if I can put a SQL query limiter over it?

  • May I know how many orders are there and what is your search query with this endpoint. – Ramkishan Suthar Dec 7 '18 at 10:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.