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.