Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 5th, 2003, 04:13 PM
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default fetch in background?

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
 
Old June 5th, 2003, 11:25 PM
mhc mhc is offline
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old June 6th, 2003, 09:53 PM
Registered User
 
Join Date: Jun 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to bhaving7
Default

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
 
Old June 11th, 2003, 09:53 AM
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 
Old June 23rd, 2003, 12:30 PM
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old June 25th, 2003, 05:13 AM
Registered User
 
Join Date: Jun 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi;

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

Rgd
 
Old June 25th, 2003, 10:39 PM
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Frankie,


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

Cheers,
Abhisek





Similar Threads
Thread Thread Starter Forum Replies Last Post
problem to fetch record using while loop Manoah Classic ASP Professional 9 July 31st, 2008 10:04 PM
Fetch Data From server ashvinm JSP Basics 2 March 10th, 2008 07:48 AM
how to fetch records from website avats ADO.NET 0 November 3rd, 2005 03:45 PM
Nested Fetch statement cole SQL Language 0 May 11th, 2005 06:47 PM
fetch value cursor to table mateenmohd SQL Server 2000 2 August 2nd, 2004 06:41 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.