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

stinga

  • 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...

Description:
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
Stinga.
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