There are some queries repeating for 70 times in my homepage. Especially these two;
SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 1
These two queries run 69 times for each. (That is 138 times for only two queries.)
@martfox was very kind enough to setup the same environment of mine to one of his servers; his copy shows 65-72 queries run for the homepage but mine changes between 104 and 520.
There are some queries repeating for 70 times in my homepage. Especially these two;
SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 1
These two queries run 69 times for each. (That is 138 times for only two queries.)
@martfox was very kind enough to setup the same environment of mine to one of his servers; his copy shows 65-72 queries run for the homepage but mine changes between 104 and 520.
Well now I checked the homepage, it has the exact same number of products at the homepage. (69).
But martfox copied my site with exacly the same files and the database; his copy shows 65 queries in total. So even it has the same count of products at homepage; it doesn't repeate like mine does.