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