In category product page, I saw invoking of the same sql multiple times.
Do you have any idea to solve them? If possible, I want to work on them together with you.
Thanks a lot.
Sounds Good. I haven't seen that one. Can you put a screen shot here so i can do little more debugging.
It is easy to find that. When we click to find queries in a category page.
e.g. 133 statements were executed, 120 of which were duplicated, 13 unique.
You can see from below link as well.
http://new.vancouverstore.ca/category/liquor?p___liquor_type%5B%5D=3
Without that kind of query duplications, AvoRed's qualtity and speed can be improved more efficiently with less resource. For now, as I test, it cannot be run with basic hosting plan because it requires a little high amount of CPU resource. I expect solving these kind of query duplicate can be an answer for production stage.
Now i get it i was thinking that you were talking about the back end category page. I am putting this one as a improvement bug and will work on it. Thanks for raising the issue.
Thanks a lot, Purvesh.
© AvoRed 2021 Privacy