DataSet
-
My problem: i have this table, with about 10 to 20 thousand records; applying a rowfilter on a dataview for this table works kind of nice; the thing is that when I have no records matching the given criteria, applying the filter takes way too long (and speed for my program is quite important). I also tried "cheating" (find/rowstatefilter = none), but it seems applying the rowStateFilter lasts about as long as applying the filter. Does anyone have any ideas? Thx
-
My problem: i have this table, with about 10 to 20 thousand records; applying a rowfilter on a dataview for this table works kind of nice; the thing is that when I have no records matching the given criteria, applying the filter takes way too long (and speed for my program is quite important). I also tried "cheating" (find/rowstatefilter = none), but it seems applying the rowStateFilter lasts about as long as applying the filter. Does anyone have any ideas? Thx
Filter it on the database server - that is what it is good at.
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar The Second EuroCPian Event will be in Brussels on the 4th of September Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way! My Blog
-
My problem: i have this table, with about 10 to 20 thousand records; applying a rowfilter on a dataview for this table works kind of nice; the thing is that when I have no records matching the given criteria, applying the filter takes way too long (and speed for my program is quite important). I also tried "cheating" (find/rowstatefilter = none), but it seems applying the rowStateFilter lasts about as long as applying the filter. Does anyone have any ideas? Thx
-
My problem: i have this table, with about 10 to 20 thousand records; applying a rowfilter on a dataview for this table works kind of nice; the thing is that when I have no records matching the given criteria, applying the filter takes way too long (and speed for my program is quite important). I also tried "cheating" (find/rowstatefilter = none), but it seems applying the rowStateFilter lasts about as long as applying the filter. Does anyone have any ideas? Thx
I agree with Colin, write your SQL so it does the filtering depending on a parameter passed into the stored procedure. There is no reason for you to be passing tens of thousands of records to a client that will only display 10-20 records on the screen at any one time. You might also want to include paging support in the SQL and the Datagrid. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome