Re: Import File / Insert Optimization Help

2006-01-23 Thread Gleb Paharenko
Hello. I'm not sure if it suitable for you case, but sometimes it is better to import data to the temporary table on the server and extract values from the fields of that table. Scott Klarenbach wrote: > I am importing records from a text file into my DB. Each record in the text > file corresp

Import File / Insert Optimization Help

2006-01-20 Thread Scott Klarenbach
I am importing records from a text file into my DB. Each record in the text file corresponds to six tables in the DB due to normalization. So for example, an inventory record containing a part, vendor, contactPerson, mpn etc...in ONE line of a text file, requires 6 inserts into the DB. Further m