[TYPO3-shop] tt_products very slow with 10.000 products

[Xose Pita]

Hi...

The problem  is / was in the class  tx_ttproducts_list_view, line  671

// code (resume)
for ($i = 0 ; $i < ($productsCount/$this->config['limit']); $i++) {
    $markerArray['###BROWSE_LINKS###'] .= $i+1;
}

The for is used to render the pagination...

Thanks Franz

2006/12/1, Franz Holzinger <franz at fholzinger.com>:
>
> 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
> _______________________________________________
> TYPO3-project-tt-products mailing list
> TYPO3-project-tt-products at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-tt-products
>
>



-- 
José M. Pita
Desarrollador web
www.tripix.net