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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])