So, I am migrating our CS-Cart installation to a new hosting environment. I've made an identical copy of all files and the database. However, the new installation is very slow, especially on the product detail page.
I started debugging and found out that the number of mysql queries show huges differences. The old server executes 876 queries when loading the product detail page; the new server 1908 queries. Does anyone have an explanation as to what causes this difference?
Also, is there any way to decrease the amount of queries being executed? I noticed some queries being executed 20+ times in one pageload, which seems a bit excessive...