Hi

Not sure if this question should be here or the Firebird list but
thought the component might have some impact.

If I have to do millions of inserts into a table is it quicker to do

a) Check to see if record exists, if not add it
or
b) Insert regardless and trap the exception triggered by a pk violation


--
Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd