![]() |
Click here to advertise with us
|
|
|||||||
| ADO.NET Anything regarding DataAdapters, DataReaders, DataSets, etc. |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|||
|
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 |
|
|||
|
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 |
|
|||
|
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. |
![]() |
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|