Slow order query in backend

[stinga]

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