Subject | interbase - firebird |
---|---|
Author | Peter Lee |
Post date | 2003-10-14T08:18:03Z |
Hello Everybody,
I'm just experimenting moving from Interbase 6.01 Open Source to Firebird
1.03... we are having some major speed issues.
Our applications are written in Delphi 6, and connect using dbExpress. On
my development machine, Windows XP, P4 2.4 Ghz (with hyperthreading),
everything is fine using IB 6.01. Once I install FB 1.03, things slow down
dramatically.
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.
The result fdb file is about 2.9mb.
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?
Thanks,
Peter Lee
-
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
I'm just experimenting moving from Interbase 6.01 Open Source to Firebird
1.03... we are having some major speed issues.
Our applications are written in Delphi 6, and connect using dbExpress. On
my development machine, Windows XP, P4 2.4 Ghz (with hyperthreading),
everything is fine using IB 6.01. Once I install FB 1.03, things slow down
dramatically.
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.
The result fdb file is about 2.9mb.
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?
Thanks,
Peter Lee
-
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