Time out issue with orders

[wcw]

I just tested the order import from my 4x store into RC2. The import went fine, except for the known issue with the missing dates. But now, with 20,000+ orders in the database, in admin the manage orders tab has an issue. When you click the link it opens with oldest orders first. When I click on the link in the header row for Order # it is supposed to reverse the display with newest at the top. It times out. The store is CSSUI, RC2, MivaSQL. I know there are issues with ORDER BY <field> DESC and MivaSQL. I've had to do workarounds with several modules because of it. Is this a Merchant or Engine issue with MivaSQL and DESC on large databases? Does 5.07 Engine fix this issue?

For those who want to see the order history in action, you can go to http://www.pinemporium.com/SFNT.html and click the order history at the top. It contains all orders placed at Emporium Plus since Sep 2000. You can use the quick lookup or you can login to see it.

[Siamese-Dream.Com]

Re: Time out issue with orders

Hey there, Bill:

You probably already know this, but you get a non secure connection warning when clicking on the Order History button (in firefox)

Also, while it is paginated and it says that I am looking at page 1 of 3, there is no OBVIOUS way to get to the next page (basically, you have to type in a 2 and then hit the enter key). I guess that is how Miva has it set up?

[wcw]

Re: Time out issue with orders

Yes, that test domain is using my other site so I could test secure urls.