Access DB and VS 2005 application

[Venedict]

Hi All,

I have develop a VB.Net application in VS 2005 with Access database. The
application need to read in 3 text file and insert record into Access
database(3 table) for 5 to 6 company. The total number of records is about
80K to 85K++ per company.

The import process is run once in a month. There is performance issue when
import the text file into the access database. The total process tooks about
1hrs+ to complete per company. If I manually run the import in access from
the text file, it tooks less than 10 mins to complete.

I'm tested with SQL 2005 Express Edition. It tooks 15 mins to complete for 1
company.

Has anyone encounter this issue? How should I resolve it?I'm using Jet OLEDB
connection.

 

[Guest]

Manual inport runs as an implicit transaction, so if that is faster,
you should try running your import process in a transaction.

(david)