I have a situation that has me absolutely perplexed.
I'm still using UltraWebGrid 10.2. I recently learned that the performance associated with this grid becomes unacceptable when the number of records in the grid approaches 100. I have a DropDownList column in the grid that provides the names of our employees when a cell in that column is clicked. The end user then selects from the list and the employee name is placed in the cell.
I've been doing some testing this morning and learned that a significant bottleneck occurs in the CellClickHandler for this drop-down grid column. The incredible thing (to me) is that it only occurs the FIRST TIME one of these cells is clicked! I have a JavaScript loop (MyGrid.Rows.length = 25) that looks like this inside this handler:
for (i=0;i<MyGrid.Rows.length;i++) {
--- Do Stuff ---
}
I capture the system time before entering the loop and again after the loop completes. For only 25 grid records, it takes appx. 4 seconds to execute the loop the FIRST TIME THROUGH! As more records are added to the grid, the response time increases geometrically. However, after the drop-down appears and I click another cell in the column, the same loop executes in only a few milliseconds.
When I first enter this loop, the logic recognizes that there are 25 records in the grid. I can't for the life of me understand why the huge performance difference after clicking a cell the first time. Can someone suggest why the performance is so bad the first time I click a cell in the column, but seems to clear up for subsequent clicks?
Hello megryan,
In order to investigate this further we need at least the following information:
- Exact build of 10.2 used (are there any Service Releases for this version installed)
- Browser used for testing and its version
- Is the grid flat or hierarchical
- What kind of dropdown you use – Template column with DropDownList or grid’s ValueList column (http://help.infragistics.com/NetAdvantage/ASPNET/2011.1/CLR4.0/?page=Infragistics4.WebUI.UltraWebGrid.v11.1~Infragistics.WebUI.UltraWebGrid.UltraGridColumn~ValueList.html)
- What kind of DataSource is used
If you can attach a sample showing this behavior this will be very helpful too.
You can also check the sample attached to this thread - http://es.infragistics.com/community/forums/p/63032/320999.aspx#320999 – to see if the same behavior is reproducible there.
Thanks Alex. In order,
1. Assembly ="Infragistics2.WebUI.UltraWebGrid.v10.2, Version=10.2.20102.2248, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"
2. I downloaded the 10.2 service release by going to your site and clicking the link
NetAdvantage for Web Client 2010 Vol. 2 - ASP.NET Service Release
3. The browser is IE9 Version 9.0.8112.16421
4. The grid is flat.
5. I use a grid value list column.
6. The Valuelist datamember (source) is a SQL stored procedure that returns 891 employee rows.
Unfortunately, I have no sample available.
Thanks for any suggestions. I must again re-iterate that only the first cell click bogs down. Subsequent clicks in the same column respond quickly.