Hi,
In our application we are using Infragistics Webgrid with Multi Bands.We are binding around 8000 records in the grid.The loading time becomes too low as it takes around 30 minutes to load 8000 records.Could you please suggest me on how to reduce the loading time or is there any way to optimise it?
We are using Infragistics 2007 v7.1 and .Net Framework 2.0
Thanks in advance
You're far from the first person with this kind of issue. A search of the WebGrid forum for "slow" returns 35 results, and a search for "performance" returns 95.
If you cannot use paging or filtering to reduce your record count, you might try those same two searches. I haven't had this problem myself, but it's an issue I try to follow, and if I recall correctly, I've seen some suggestions that did prove helpful.
Ed is as usual right - 8,000 rows, especially with complex data and many columns can be hard to display at once, so you can try searching the forums forways to alleviate that.
Paging is one of the best ways, you just need to make sure you fetch only the number of rows you need from datasource for the currently displayed page. In addition to Filtering, I would also recommend AJAX - this is load rows on demand (for example for child bands) only when end-users request them by pressing the expand image.
We have more than 10 AJAX examples for grid here:
http://samples.infragistics.com/2008.2/webfeaturebrowser/default.htm
(available in the AJAX tab from the left navigation)