How can i make dataupdation faster?

[arjmand]

Hi friends,

I have a problem with the amount of time my application is taking to update the database under the following case:
I have to fetch more than 2500 records from a database table and then update other database table with the fetched records, I have done both the things successfully, but the problem is, the amount of time my apllication is taking to do it is more than 2 mins. Is there a way by which i could minimize this huge time taken by my application.

Note 1.) Databases are different.
2.) currently i am doing it with the help of data adapters, datasets, datarows and commandbuilder.

Thanx in advance

 

[Administrator]

Set the DataAdapter BatchSize property if your database supports it, i.e. da.batchsize =25.

If you're not using Timestamps for concurrency checking, this will also speed up the operation, set the corresponding property on the dataadapter for rowversion checking, etc.

Optimize your SQL statements, if possible.

 

[arjmand]

Thank you Neal

Thank you Neal for ur time n reply, but i found the way out, i was doing a slight mistake in my approach which i rectified. Things are now going smoothly.