View Issue Details

IDProjectCategoryView StatusLast Update
0002152OXID eShop (all versions)2. ----- eShop backend (admin) -----public2012-12-07 13:59
Status resolvedResolutionfixed 
Product Version4.4.3 revision 30016 
Target VersionFixed in Version4.4.5 revision 31315 
Summary0002152: AJAX lists are almost unusable when there are lot of products
DescriptionWhen there are lot of thousand products in the eShop (i.e. 50 thousand articles), the AJAX lists becomes almost unusable.
I.e. when AJAX list is opened in the Shipping Cost Rules section, to assign some products, it took some half a minute until it loaded initial page (this might be because of building category tree with 3 thousand items). But then - when I scrolled the scrollbar down (dragged it down) - it started automatical reloading of the list of products each second (without touching it). Looks like it tries to get and display the particular portion of data for each point passed in scroll bar (not directly to this point, when mouse button is released). This behavior took for a few minutes. Then (probably, because articles were cached) it worked correctly.
Also the filtering of articles by Categories is difficult and needs a lot of time.
Need to check if the defined timeout works, when dragging scrollbar (it should wait until the status not changes any more, only then load needed articles).
Additional InformationThe feature request to improve the process of displaying articles in AJAX lists will be written to User Voice. Need some ideas how to improve this (display list only at some points, filter only on some actions, etc.)
PHP Versionany
Database Versionany


related to 0002127 resolvedarvydas_vapsva shipping cost rules: query time - increases exponentially 


There are no notes attached to this issue.