Oleg Lebedev wrote:

> Inserting 1,500,000 rows took 30mins., which is not so bad.
> I have another table, which contains 6,000,000 rows, so I guess I will
> be having a long lunch today :)

:)

> I am not sure if I have my write-back cache enabled or not. I will make
> sure to disable it before I do the next insert.

Snice you're controlling the process you can enable it, i.e. set the
forced writes off. It's good to turn it on in production environment, so
that power failure doesn't corrupt the database.

> Is there a way to find out whether the async write is enabled or
> disabled?

Are are many ways, for example you can connect to database with isql,
and issue "SHOW DATABASE" command. Watch for "Forced Writes" line.

--
Milan Babuskov
http://fbexport.sourceforge.net