Subject Re: [ib-support] When do FB/IB 'flush' to disk?
Author Ivan Prenosil
> From: Phil Shrimpton <phil@...>
> > Wouldn't a better solution be to set Forced Writes = ON?
> Too slow, is the simple answer. The app in question is collection a lot a
> data and importing it into the database whilst performing additional
> processing. With forced writes OFF it takes about 8-9 hours to import a days
> data, with them ON it takes 3-4 times as long (which is longer than a day)

What is volume of imported data ? How many rows, how many blobs ?
Any triggers, fk constraints, indexes involved ?
Have you tried to use database with preallocated space ?