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?