Hi, Quick question when working with large'ish datasets, how well do grids generally perform when working with large volume of data (without having to resort to paging)? Is there a recommended max grid row size that one should not go beyond? One of the applications we have in mind may be using grids with tens or even hundreds of thousands of rows and I built a sample grid with 10,000 rows and noticed the grid did take a while to initially populate and was generally sluggish in use. Thanks, Craig |
Hi Craig, Formspider Grid is performs really well with large data sets. It uses deferred rendering techniques, so even if you load it up with many rows, it will not try to render them all at once. It renders only the ones that can be seen by the user and dynamically adds the new rows to the grid while the user is scrolling. However 10K rows is challenging for any grid. That's where you start to push the limits of the browsers. Hi Yalim, Thanks for the response; for a few hundred or even a few thousand rows grids do seem to perform very well but getting to 10k and beyond performance does decrease considerably; I have to remind myself that when working with FS that it is not FS that is the bottleneck but the browser itself. Thanks, Craig.
(28 Apr '13, 05:18)
Craig
At some point we will implement infinite scrolling. Once that's implemented I think we can even circumvent this browser limitation.
(28 Apr '13, 05:23)
Yalim Gerger ♦♦
Hi Craig, You may also consider using a paging mechanism while working with large datasets. You can easily implement such a mechanism through the paging components. Regards,
(29 Apr '13, 02:46)
Ibrahim Sand... ♦♦
Hi Ibrahim, Thanks for your input; I have looked at paging and certainly in some scenarios it will be a good idea but in others scenarios not so good. Quick question about grids or rather datasources, once the data has been fetched from the DBand delivered to a grid, is it possible to iterate through the data row by row and also it is possible to read row X without performing the fetch again? Also, once data is in a grid (whether paging or not), what kind of programmatic row navigation is available in terms of setting the current row, i.e. first row, last row, set row X? Thanks, Craig
(29 Apr '13, 03:29)
Craig
Hi Craig, Once the data has been fetched from the DBand delivered to a grid, is it possible to iterate through the data row by row? It is possible to read row X without performing the fetch again?
What kind of programmatic row navigation is available in terms of setting the current row, i.e. first row, last row, set row X?
Hope this helps,
(29 Apr '13, 04:21)
Ibrahim Sand... ♦♦
Hi Ibrahim, That's great, thanks :) One more question, is it possible to get a row from the datasource using its position in the datasource, i.e. can I get row 2 which would be the 2nd row displayed in the grid? Thanks, Craig.
(29 Apr '13, 14:32)
Craig
Hi Craig, Such an API does not currently exist but as a temporary solution, you can achieve this by setting the row with the specified position as the current row using Regards,
(29 Apr '13, 15:12)
Ibrahim Sand... ♦♦
showing 5 of 7
show 2 more comments
|