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