Hello, looking for some help.
I have a requirement to query a database for a customer that has over 7,000 rows.
When I run the query, to return 7000 rows, it fails (obviously too much)
Is there a way to query for the 7000 rows but only query and load 15 or so at a time? And when the user clicks the next arrow on the paging grid, it only loads 15-30? So that the interface isn't overloaded?
They aren't going to page through 7,000 records, 15 at a time, but the requirements still want to be able to have an overall customer view.
Thanks,
Discussion posts and replies are publicly visible
Yes, add appropriate paging info to your query.
You should never configure a query to pull back all data, as this is not a scalable design paradigm. Set the paging info batch size to some reasonable number, like 10 or 20, and you should have better results.
This is the best way to reduce the time the query takes to execute. Please also add selection if you do not want to use all the table columns.