Jump to content



Latest News: (loading..)

Issue Information

  • #000439

  • 0 - None Assigned

  • New

  • 2.3.1

  • -

Issue Confirmations

  • Yes (0)No (0)
Photo

SQL optimisation Order & customer for large daa

Posted by Gyakutsuki on 14 March 2012 - 08:56 AM

When there are lof of data in order.php and customers.php  (admin), we can have a time error, because the files read all the data base instead read only the first 20 data on the page (list).
I think the pb come the split function.

Hi,

how many customers do you have? We are over 3000-4000 and dont find this problem. The split page class use page limits in sql query. Did you set it?

Regards,
Gergely

I speak more 40 000 order or customers. The pb is the sql do not read the 20 first customer or order but all the list every time

Could you run directly the 20 first splitted orders and customers query in the sql engine? How many the time results?

I think the data table error is more possible in this case when the 20 first orders or customers use the same table records in these queries.

I have to say that probably the 20 first customers done the 20 first orders.

I haven't this data, just i want put the problem when I meet on a client. The error come on time error.
Just osc must to updrade, I think it's interesting to try to optimize this.

Regards.