On 14 Oct 2003 at 22:28, Peter Lee wrote:

> Thanks for the info - just to do some comparisons, how do you turn forced
> writes off?

Use gfix or Service API (probably better if you create the database in
application).

> Also, what do you mean by metadata operations - in this create / populate
> process, we create 114 tables, with 10 generators and triggers. Each table
> would probably have one to two indexes... some less some more. We'd insert
> about 4000 records into the tables... with individual insert statements -
> perhaps 5-6 fields on average for each insert statement.

When you create the database structure, it's usually a lot of page
writes. With FW ON, each page is written directly to disk, while with FF
OFF they may end in OS filesystem cache and write could be defered.

Best regards
Pavel Cisar (ICQ: 89017288)
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information