[TYPO3-commerce] Huge number of queries

[Dmitry Pikhno]

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