Hi.
We have a huge VirtueMart database (15000+ orders), and VMInvoice Invoices list takes VERY long to load: on a dedicated server with 4G ram and quad core Xeon takes up to 15 seconds.
This is not a big issue "per-se", but when you have five or more concurrent users browsing that page becomes a intensive job for the server.

I believe this is because every time the page is loaded PDFs are checked on disk. Isn't it possible to scan for the PDF of the current page only?

thanks

Hello,

we are preparing optimalisation for this problem. It will be released in next version of VM Invoice.

Hello. You are right, it was not because of lots of PDF checked, it was because un-optimalized SQL query. We just released new version 2.0.23, you should check if your problem is fixed.