hi all
this is my first thread in this VB forums ,

now i using adodc connection with ODBC mysql database .
how i can make the adodc read multi row at the time , not single row at the time, to speed up the process , ?
example of my work

Code:
for i = 0 to adodc1.recoredset.recoredcount 
adodc2.addnew 
adodc2.recoredset.fields(0) = adodc1.recoredset.fields(0)
adodc2.recoredset.fields(1) = adodc1.recoredset.fields(1)
adodc2.update 
next i
please help me with any advice that will may speed my process ..
regards