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.
Thanks! ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings