View Full Version : What is the maximum number of records in the datagrid that fetches data efficiently?

11 Dec 2012, 1:27 AM
Hi Fellow Developers,

As of this writing, we have a User Interface (UI) with 1 datagrid on it. It is in fact only using one database table to fetch and then display the data on the said datagrid.

A month ago since it was deployed, upon loading such page of the said UI, its behavior is performing very fast to fetch data. However, recently when it has more than 15,000 records already, we are now experiencing sluggish data fetching which runs beyond 4 to 5 minutes of waiting for the records to display at the datagrid. If the cause is more on the rapid grown of data, then if we will delete some old data, what is the ideal or maximum number of records that we should maintain in order to maintain also its normal speed?

Please advise.

Thank you.

11 Dec 2012, 3:23 AM
Personally I do not see the need for displaying more then 10's or maybe 100's of records at once. Most (non-power) users couldn't handle that. I would go for filtered or paged views.

If you really want one list with all records, then do it virtually and go for infinitive scrolling. This allows you to fetch (and display) the data in small chunks but still provide the same user experience