S
Stefan Marquardt
Guest
I loaded the Telerik winform demo and placed a GridView on my form and tried a few ways to populate it with data. 1 Query to the database with WHERE condition to limit records 2 Query to a temp-table create from the same WHERE condition 3 Dataset with the same temp-table 4 Unbounded, adding rows in a EACH query Option 1 was done very fast, binding-source, read schema from table and attach the query handle. But then I clicked on a col header and expected fast sorting (~1300 records) but no, I can go for a coffee. VST (protop) shows I high access to the table, much more than the initially load. Option 2 and 3 are faster because the temp-table is in memory but still too slow. And the needed time depends on the selected col. Then I added indexes to the temp-table to every col I like to sort, no change. Option 4 needs a few seconds to fill the grid but then I can click on any col and the sorting is done at once. Result: Bounded fills the grid fast but sorting is not really possible Unbounded fills slow but sorting is as fast as expected. Until now I have no idea what happens in the background to get a clue about the logic behind Who has the same experience and knows perhaps the trick?
Continue reading...
Continue reading...