RE: [sqr-users] Insert -SQR

["Christopher Wanko" <WankoC@wyeth.com>]

>>> 
Would it be better to load all the records into a temp table and then drop
the index on the insert target table, insert the records from the temp table
into the target table and then recreate the index on the target table after
the insert or is just this recreating the problem with the temp table?
>>>

For inserting (potentially) eight million rows, it might be better to take a 
flat file of inputs, process it with SQR to create a flatfile output, then 
drop/add the insert table with updated rows.  A bulk insert/ bulk copy without 
indicies is always faster than row-by-row inserts, and if you write your SQR 
defensively, you'll guarantee non-duplicated data going in.

An added bonus is a nice error file to parse at your leisure.

-Chris




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users