sql cache method

[gsdcypher]

I am trying to use the best method for my site. In the description below, how many products/categories would justify medium and how many large?


None. SQL queries are not cached at all. If you have very few products/categories you might actually find this gives the best speed for your site.

Database. SQL queries are cached to a database table. Sounds strange but this might provide a speed increase for sites with medium numbers of products/categories.

File. SQL Queries are cached to your server's hard disk. For this to work you must ensure that the directory where queries are cached to is writeable by the web server. This method is probably most suitable for sites with a large number of products/categories.

I will have approx 30 cats and 375 - 400 products

thanks.