adodc1 multi row at the time .

[majroo7]

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

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

[firoz.raj]

Why did y take two Adodc control at the form ?.what do y want to achieve ?.

[majroo7]

hi

thank you for replay

because we need to copy table from database 1 to other database 2

and the system process one row at the time which is slowly and i want to speed up by take multi rows .