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

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.

Thanks,

Peter Lee

At 14/10/2003, you wrote:

>Hi,
>
>On 14 Oct 2003 at 18:18, Peter Lee wrote:
>
> > Hello Everybody,
> >
> > I'm just experimenting moving from Interbase 6.01 Open Source to Firebird
> > 1.03... we are having some major speed issues.
> >
> > Specifically, our application has the ability to automatically create it's
> > .fdb file if it can't find one locally at startup. It does this by using
> > an interbase express component to create the database file, and then
> > populates it with create tables / inserts that come out of a dll. With ib
> > 6.01, this takes about 4-5 seconds from start to finish, with fb 1.03, it
> > takes about 5 minutes.
> >
> > I've turned off the system restore feature, our database is already called
> > .fdb, and I've turned off hyperthreading in the bios.
> >
> > Is there anything that I'm missing?
>
>On Win32 platform FB has Forced Writes ON, while IB has it disabled,
>hence the speed difference, especially on extensive metadata operations.
>
>Best regards
>Pavel Cisar (ICQ: 89017288)
>http://www.ibphoenix.com
>For all your upto date Firebird and
>InterBase information
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

-
Peter Lee Mobile: +61 412 011 174 ptle@...
-----------------------------------------------------------------------
Rising Software Australia Pty. Ltd. http://www.risingsoftware.com/
Publishers of 'Auralia' - Ear Training and 'Musition' - Theory Training
Ph: +61 3 9481 3320 FAX: +61 3 9481 3380 USA Freecall: 1 888 667 7839