Robert martin wrote:

>
> Jason Wharton wrote:
>>> 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
>>>
>> No, this is very inefficient.
>>
> Ta. This is how we are currently doing it :-(

That should be: Hooray, we can improve this ;o)

How long is each record and what kind of performance do you typically get?

Set