Discussion

Reduce duplicated query in showing category products

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.

Purvesh
Purvesh
1 week ago

Sounds Good. I haven't seen that one. Can you put a screen shot here so i can do little more debugging.

humble92
humble92
2 days ago

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.

Purvesh
Purvesh
2 days ago

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.

humble92
humble92
2 days ago

Thanks a lot, Purvesh.

Want to contribute?

© AvoRed 2021 Privacy