admin/orders and admin/customers - limit rows

[lindasdd]

Due to the size of my database, admin/orders and admin/customers puts a strain on the database to load when loading just the default.

If I change the maximum value to a low amount, the query is still pulling all the data, it is just changing the pagination (I think).

I'd like to either limit the default data pull to something like 10 entries or change the whole page so no sql is queried until there is an entry in the search boxes.

I figure locating the correct SQL statement and adding a LIMIT would be the easiest option, but I'm having trouble locating the correct query.

[dbltoe]

https://docs.zen-cart.com/user/admin...customers_page

Those are default at 50 and usually load in less than a second. You may have some other, underlying problem.

We have several sites with over 5000 orders and customers and have no such problems.

[lindasdd]

I don't know at what level things start to get a little dicier, but my customers database has over 400K entries and my orders table has over 500K.

I could archive some of that, except it would be a lot easier to just not call ALL of it to appear when I don't need any of it (I just need to get to a search input).

[DrByte]

A query update to the orders page in v1.5.7 has improved load time.