Ivan Prenosil wrote:

>I have inserted several millions records inside one transaction
>and have not noticed any slow down (without disabling auto_undo).
>Perhaps the situation is different if you have huge number of indexes ?
>
>Ivan
>
>
>

People,

Now I am puzzled... :-/

One should or shoudn't commit after a bunch of records ?

I prefer if I could start a transaction, import a zillion records commit
at the end, or rollback in any exception, than to commit in batches...

What could lead to poor performance after 10k records inserts, and why
Ivan didn't get this penalty ? Ivan, could you please tell me your
little secret ? :-)

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.1 - Release Date: 03/06/2005