[TYPO3-commerce] RFC Bug: #39420 - Improve performance in class.tx_commerce_db_category.php

[Ingo Schmitt]

Hi Georg,


after your change products without articles could be in the list. This will lead to problems in the rendering of the lists, since there a product should always have an article. 

Best regards

Ingo

> This is an SVN Patch request
> 
> Type: Bugfix
> 
> Bugtracker reference: http://forge.typo3.org/issues/39420
> 
> Branches: trunk
> 
> Problem:
> The query for getting products in class.tx_commerce_db_category.php
> could be simplified.
> Don't know why it will query articles and prices too, IMO this does not
> make sense and leads to a big while loop if you have more than 1 article
> / price per product ... (immagine a shop with many different articles
> and different prices)
> 
> Solution:
> Attached patch queries only products.
> 
> Additional Notes:
> 
> 
> regards,
> Georg
> <class.tx_commerce_db_category.patch2>_______________________________________________
> TYPO3-team-commerce mailing list
> TYPO3-team-commerce at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-team-commerce