I'm now wishing that adonet was a little less 'disconnected'. I've got an entity table of around 200k records. These are all valid entries and need to all show up on a grid that sorts (on KeyUp) based on the characters in a text box. The scroll bar also needs to be able to be used, of course. The .Fill() call takes over 10 seconds on a fairly fast and unused server. That'll get longer once that server has more of a load on it. What's the best way to grab the ones that show and then fetch the rest in the background? I can't have users sit there for 10 seconds waiting unless there's no way around it.

Didn't the old version of the adodb datagrid do this easily?

I'm only bringing back the data that I have to display and I'm using SqlServer 2000 with an OleDb provider.

Thanks for any help.
Mark

The performance of DataGrid in .NET framework is worse.

You can have a try on FlexGrid.NET from ComponentOne. This grid is an unbounded one. Performance is good and you need not wait for 10 secounds.

I try others like UltraWinGrid (from Infragistics). The performance is not good also.

mhc

rather tha usng the Datagrid , try using ComponentOne's TrueDB grid which is much more flexible and versatile i hope that it will solve ur problem..



Allways try and U'll Be successful
Bhavin

Thanks for the ideas. I went with a seperate lookup table that is maintained by the parent table (PK on id) through some triggers. This let me set a PK on the name+id. I'm just bringing back 150 records on each keystroke and since the PK holds an alpha sort, I get back what I need and in the right order. And it's fast enough that you just see a slight hesitation after each keystroke.

I know that, at some point, some user is going to scroll down more than 15 times and call our help desk wondering where the rest of the list is. It's the best I could do.

Hi,

A better way to implement this would be to use paging. You have tried doing the same by displaying 150 records at a time. You can use different kinds of paging.
Here are some links that you may visit for more help on paging:
1. http://www.msdnaa.net/Resources/Display.aspx?ResID=1612
2. http://www.4guysfromrolla.com/webtech/072101-1.2.shtml
3. http://www.123aspx.com/resdetail.aspx?res=244

Hope this helps!!

Cheers,
Abhisek

Hi;

   Could I ask where can I get hold of the flexGrid .Net?

Rgd

Hi Frankie,


Visit this site for the ComponentOne FlexGrid.
http://www.componentone.com/products...1&ProductID=17

Cheers,
Abhisek