>>>Can you switch off buffering and use a transaction instead ?
>>
>>No, I don't think it's advisable. Transaction time should be minimum.
>
>Haven't followed all: Do you have buffering AND transactions active at the same time in your code ?
>
>regards
>
>thomas

No, we use transaction only when committing changes. E.g. first we made lots of insertions/replacements in lots of tables in buffering 5 mode and at the end of the process we commit all changes using transaction. Pretty much standard approach.