[TYPO3-shop] tt_products very slow with 10.000 products

[Franz Holzinger]

Hello Xose,

> We are developing a virtual book store based on tt_products. We have now a
> big problem with a 10.000 products database in the list view. It takes over
> 20sc to produce de page on a high web server. A medium book store has about
> 200.000 products...
> 
> Somebody has any idea, thanks in advance.,

Which SQL queries does your shop produce?

* Try to optimize this querie with database table keys on the mostly 
asked fields.
* Do not list all products in the select view. Use the category as a filter.
* Set the pid_list in TypoScript for subpages of the shop. Then only a 
smaller list of products will be searched, only those relevant for a page.
* Do not use the minibasket because this would deactivate the cache.

Greets,

Franz