Question Ado.net Performance vs. ADO

biju · #1 (**permalink**) 07-08-2009, 5:07 AM

Hi all,
I am new to here and ADO.net
I am just started to convert my vb6 app to vb.net.
In my application, there is table with more than 5,00,000 records.
I need to load all this records once ...and for this, my vb6 application with ado 2.6 takes almost 10 sec. to load data. and for the same my ado.net takes almost 30+ sec.

i am t using data table and filled using a dataadaper thats all.
how can i able to speed up this
sorry for my bad English

:

Thanks all

cjard · #2 (**permalink**) 07-08-2009, 7:25 AM

you want to load 5 million records into the client? Why?

biju · #3 (**permalink**) 07-08-2009, 9:35 AM

Quote:

Originally Posted by cjard

you want to load 5 million records into the client? Why?

To create a lookup table

cjard · #4 (**permalink**) 07-09-2009, 11:32 AM

And this genuinely strikes you as a sensible thing to do?

biju · #5 (**permalink**) 07-09-2009, 1:21 PM

This is a test case i have created . My actual appliaction may have upto
100000 records.
it is a medicine data base. There are thousands of medicines and each medicine may manufacured by hundreads of manufactures.

So if the user select all products of all manufacures, the number of records may more than 100000. My Current application displaying this with in 10 sec.

thanks

cjard · #6 (**permalink**) 07-09-2009, 1:25 PM

Sure am glad I don't have to use that program. What use is a grid with 100,000 entries? Am I gonna scroll the whole lot and look for the item I want? No..

biju · #7 (**permalink**) 07-09-2009, 1:41 PM

no .. the list will not always populate 100000 records.
i have provided two combos.. first one to select the medicine and the secod one is for manufacturer. All this two combos have an element captioned "<All> ".
so . some users may select both combos with value <All> ,then select the seach button.

As i already discussed, its working fine in vb6 with ADO. and what i am wondering is ,why it is not in vb.Net. AFIK, ADO.net must have better performance than ADO. right ?. Since i am new to ADO.Net , i need to clarify the performance lag is due to my coding style or not, and need to know how i can able to get the maximum performance... atleast upto ADO can deliver.

Thanks & regards.

cjard · #8 (**permalink**) 07-10-2009, 4:35 AM

And really, what are they then going to do with all 100,000 records downloaded when both are set to <All> ?

We had the same problem about 3 years ago witha manager at work who wanted to be able to download all 70 million transactions records into a grid and just scroll up and down them. Why? Because he wanted to look at them. And maybe sort them so he could find the one he wanted. This is where the deverlopers step in and say "don't be so silly - we're not going to code that. you'll use the search function like everyone else"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)