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

asked 27 Apr '13, 20:33

Craig's gravatar image

Craig
1.1k244
accept rate: 6%


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.

link

answered 28 Apr '13, 05:11

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

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,
Ibrahim

(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?
Yes, the datasource always keeps the copy of the data delivered to a grid. Therefore, you can access these rows through the datasource APIs. If you need to loop through all rows, you can use api_datasource.getRows API. If you need to loop through the rows meeting certain criteria, you can use api_datasource.getQuery API.

It is possible to read row X without performing the fetch again?
You can access a specific row in two ways:

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,
Ibrahim

(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 api_datasource.setCurrentRowByRowNR and then calling api_datasource.getRow API. Please note that since this solution changes the current row, you may want to save the row id of the initial current row and then set it as current again using api_datasource.setCurrentRow API.

Regards,
Ibrahim

(29 Apr '13, 15:12) Ibrahim Sand... ♦♦
showing 5 of 7 show 2 more comments
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×85

Asked: 27 Apr '13, 20:33

Seen: 1,424 times

Last updated: 29 Apr '13, 15:12


© Copyright Gerger 2017