> >>I'm migrating data from DBFs to firebird tables. The thing is that when

the

> >>ammount of records is bigger (10000 records), the inserts become slower.
> >>Do I have to change something ?. Do I have to perform some clean up?
> >
> > It's advisable to commit in batches of about 5000 - 8000 records,
> > especially if you don't have a lot of memory on the server. The server
> > builds up an auto-undo log structure in memory for inserts, which will

be

> > reset when the transaction commits.
>
> Right, but Firebird is clever enough to not hold undo-logs
> for _all_ commands executed inside transaction.
> After some point the undo-logs are discarded.

Huh? How does a "rollback" work then?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com