You didn't tell how is your import process, anyway, I would sugest to
you a few things:

1) Try FB 1.5.2
2) Disable all indexes and triggers before "importing" the data, and
reactivate them at the end of the proccess.
3) Be sure to commit from time to time during the import process.
You can try diferent values, like commit at every 1,000 insertions.
4) If you like to test, give FB 2.0 snapshot a try and see if it
causes some diference.

Carlos
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br



UG> hello!

UG> we are currently evaluating migration from interbase 6.5 to firebird.

UG> for testing purpose FB (superserver 1.5.1) is installed on a windows 2k
UG> professional host.
UG> after importing some data the database size is about 500 MB. the import
UG> has been done in three steps, each step added nearly the same amount of
UG> data to the database.

UG> now, after the last import the CPU-load remains at 100%, even after 15
UG> hours; there is no user connected.

UG> is there an explanation for this? and, is there a possibility to cause
UG> FB to free the CPU-load without restarting the FB-process?

UG> thanks in advance,

UG> /uwe









UG> Yahoo! Groups Links