From: Velen (velenbiz-mu.com)
Date: Thu Mar 20 2008 - 12:41:58 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

Actually I am updating TableA in DatabaseA with values from TableB in DatabaseB. Database B is on a stand alone PC. I'm using VB6 to create a .txt file containing data from TableB then using VB6 once more to recronstruct the table in DatabaseA then remove all data which are already in TableA and insert the remaining.

This is working fine but as my table is growing bigger the process is taking more time (about 5 mins for 250,000 records)

How can I optimise this process? and What are the alternatives available ?

Thanks

Regards,

Velen

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]