Speed up an import

From: Michael G. Schneider <mgs_software_at_compuserve.com>
Date: 1997/11/03
Message-ID: <01bce863$58b4c6e0$0201dede@mum>#1/1

I have to import some data from a textfile into a table. For being able to give detailed information to the user, I do this by calling a Stored Procedure again and again (from Visual Basic). By catching any errors, I can for example explain 'row 2000 could not be inserted as the UNIQUE clause has been vialoated'.

This works, but it is not too fast.

I already drop all indexes and rebuild them after the import. This speeds up the operation considerably, but are there other things I could do?

Can I somehow lock the entire table for exclusive access? Would this make the import quicker?

Any other ideas?

Michael G. Schneider

mgs_software_at_compuserve.com Received on Mon Nov 03 1997 - 00:00:00 CST