PDA

View Full Version : Large Number of Records and Processing Time



vinothsencha
8 Apr 2014, 8:43 AM
Title: Displaying large number of records in Grid


I have 2 questions.


1. Regarding more number of records in Grid
I need to display more number of records (around 15,000) in grid panel.
What is the best and efficient way to do this? If possible, Please provide some examples.


2. How to increase response time in browser / iis?
I am using Firefox browser.
when i fetch data from sql through Ajax request, it takes around one and a half minute to get the response.
I have increased ajax timeout by setting 'timeout: 90000'. But the browser is getting hanged.
How to resolve this?

scottmartin
9 Apr 2014, 12:05 PM
You can use one of the following:

-Buffered renderer


plugins: {
ptype: 'bufferedrenderer',
trailingBufferZone: 20, // Keep 20 rows rendered in the table behind scroll
leadingBufferZone: 50 // Keep 50 rows rendered in the table ahead of scroll
},


-Buffered store
-Paging

It is not recommended to place that many records in a grid without one of the above options.