best practice in retrieving contents of a flat file, then saving to a database.

currently i'm still using the sdf method of clipper to read, fastest, contents of a file.

i tried dts from sql, but the time elapsed is quite noticeable.

help please

Hi,
I havent noticed any appreciable delay in the DTS read. Are you importing into a table with indexes? As this will definitly slow it down.
You could also try the bulkcpy utility that comes with SQL.
What version of SQL are you running?
K

____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

The bulk import that comes with SQL would be the quickest way (if you can use it).  Back in like 2001 I had to import around 40million pieces of info in a text file into a database table, simple insert commands took about 5-10 hours to run.  Bulk insert took about 30 seconds-1min.



____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

thanks for the info. really helped a lot. thanks masters.