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