View Issue Details

IDProjectCategoryView StatusLast Update
0001808OXID eShop (all versions)4.05. Performancepublic2012-12-10 13:29
Reportertomas_liubinas Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Fixed in Version4.4.3 revision 30016 
Summary0001808: Suboptimal query for price select
DescriptionThere exists query:

select count(oxarticles.oxid) from oxarticles where oxarticles.oxid in
(select if( oxparentid='', oxid, oxparentid ) as id from oxarticles
where oxprice >= 0 and oxprice <= 9.99 ) and oxarticles.oxissearch = 1
and ( oxarticles.oxactive = 1 );

In some shop it takes almost 30 secs to execute. Price selection could be optimised here a lot.
TagsPerformance
Theme
BrowserAll
PHP Versionany
Database Versionany

Activities

dominik_ziegler

2010-06-11 16:46

reporter   ~0003175

We were able to reproduce this bug in an PE 4.3.2 from one of our customers. The shop contains at least 5,300 entries in the oxarticles table (much multidimensional variants). The query needs more than two minutes for completion. That is totally too much for the MySQL server.