[TYPO3-commerce] Huge number of queries

[seg at softvision.de]

And have you some ideas to handle this in a better way?

***************************************
SoftVision Media GmbH

Sascha Egerer

Firmensitz:
Kurfürstenstraße 15, 36037 Fulda

Telefon. 0661.242 767.0
Telefax. 0661.242 767.1

eMail. seg(AT)softvision.de
web. www.softvision-media.de

Registergericht:
Amtsgericht Fulda, HRB 2278

Geschäftsführer:
Christian Schiller
***************************************
We solve problems!
***************************************

"Dmitry Pikhno" <dpi at goldenplanet.com> schrieb im Newsbeitrag 
news:<mailman.25035.1219051518.4573.typo3-project-commerce at lists.netfielders.de>...
> 
> i have page that list 20 products
> each product has 20 articles (color/size combination)
> each article has price
> 
> let's calculate
> 
> 20 queries to get products
> 20*20 = 400 queries to get articles
> 400 queries to get prices
> 400 queries to attributes
> 
> 
> there are a lot of queries for moneylib and DeliveryCost but they are
> the same and query cache handles them.
> 
> so we have 1220 unique queries. pretty nice.
> 
> in ideal world it should takes 4 queries i think
> select all products where (category = N)
> select all articles where (uid_product = P1 OR uid_product = P2 ...)
> select all prices where (uid_article = A1 OR uid_article = A2 ...)
> select all attributes where (uid_article = A1 OR uid_article = A2)
> 
> i have special page in shop that display 80 products. Page crashes
> with timeout (more then 30sec)
> 
> -- 
> Dmitry Pikhno
> 
>