Author Topic: Slow order query in backend  (Read 3335 times)


  • Contributing Developer
  • Full Member
  • *
  • Posts: 872
    • Squangle ltd
Slow order query in backend
« on: February 17, 2010, 22:39:48 pm »
Not sure if it is worth reporting this since this board has gone to 'archiv' status...

When viewing an order in the backend, it takes ages to respond.
Very slow when adding/altering an order.

VirtueMart Version:
1.1.2 stable

Joomla/Mambo Version:
Joomla! 1.5.10 Production/Stable [ Wohmamni ] 27-March-2009 23:00 GMT

Steps to replicate:
Load 40,000 products into system, create order, view.

Proposed fix(es):
I believe the issue is that the DB has to query 40,000+ rows and return them to the browser to create the drop down list, in case you want to add another product.
This needs to be a popup box, preferably with a query to slim things down a bit.
So rather than return all 40,000+ rows to the browser ask the user for something to query on then return the rows with that in
(This is the way Oracle applications is done, I am a Ex Oracle DBA)

Bugtracker task #:
Enter the bugtracker task #/url when submitted.

System info:
Apache/2.2.9 (Ubuntu) PHP/5.2.6-2ubuntu4.3 with Suhosin-Patch mod_perl/2.0.4 Perl/v5.10.0
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4