很多小的sql语句会大大减慢我的网站速度

Question

I have a zen-cart with 25-30 categories. On the front page of the site each category will get it's own little area in which the 4 best selling products in that category will be displayed.

Being a bit of a noob the best way I can think of doing this is to have a single sql statement for each category which picks out the best sellers each time the page loads. I've read somewhere that you're best to limit the amount of sql statements so as not to affect site speed.

Would doing it this way be very much slower?

Is there a more sensible way of doing this?

Answer 1

That highly depends on the server backing your website. But 25 to 30 queries shouldn't have a major impact on the page performance.

A better way would be to design a database query that fetches all the items with one query. But to help you doing so we'd need the schema of your database.

Also in case you have to do many similar queries there is the options to use "prepared queries" that usually speed up the performance a good bit.

After all generally speaking, if you are new to working with database, its often better to design a few more small queries that are easily structures and can be handled by you, then one large query that has the potential to contain errors and maybe slows the database down more then then multiple small queries.