I have already programmed this part but it is taking very long time. Approximately 3 hours to import and process 1.3 million records. There are 26 fields and from these 7 are Blob fields.

Ok let me try and in greater details.

I have developed a software which contains a lot of data in it.

After two years I was asked to upgrade the software. In the upgrade process I have added many new tables and fields in existing Tables as requested.

The client has started using this software. Now the client wants to import old data in the new software.

I have programmed this part but it is taking very long because we have to verify all the records that are existing in the new version and update all the data that is already existing, insert all the data that is not existing, etc. This checking existing of record and verifying each field and updating those fields as needed, etc. is taking a lot of time.

Can someone please provide tips that will help in speeding up the import of old data.

TIA

Yogi Yang