On 2003.07.07 11:56 Mat wrote:
> I believe that its more efficient to group INSERT's together and COMMIT
> them in groups.
> However, I am automatically entering a lot of data and some of its is
> not unique. How can I reap the benefits of using BEGIN and COMMIT
> without the whole block of transactions failing if one is duplicated.
Best I could guess would be that you'll need to pre-process the data to
ensure that the data is good.
Take care,
Jay