[Firebird-test] Firebird Win32 (any version) slow on some Databases on 1st connection.

[mrqzzz <mr...@ya...>]

Hi all.
Has anyone experienced this:
After a reboot is done on the Firebird Server (any version) machine running
Windows (any Windows version), i connect to a database (no particular
structure, size about 20 Mb, no Blobs), and connection is immediate (any
client : IBX, IBO, even Java), then as soon as i start a transaction, the
Firebird server "freezes" for several seconds (even 2 minutes on some
DBs!!), the Hard disk looks very busy,  then everything goes on regularly.
Any other further transaction start happens instantly, as it should.
If the server is rebooted, the same freeze happens when the first
transaction is started!

Notes:
-It happens on a few DBs only, and always on the 1st connection after a
reboot
-The freeze happens by simply starting a transaction
-The Dbs are intact and coerent (backup & restore goes ok)
-There are 20 or 30 tables, many Fk, some Sp, some Views, no Blobs.
-The time seems to increase with the DB size
-I had this problem on some DBs ever since old Interbase 5.x
-The freeze still happens with ANY Firebird version,
-The freeze happens on ANY Windows version (95/98/Me/2000/XP) even with 1 Mb
RAM.

I suppose that during this "freeze", Firebird is inspecting the DB
structure...?
Does anybody experience this ????
If someone is interested in testing this issue, e-mail me directly i can
send a 2Mb ZIP with a "freezing" DB.


Any help is really appreciated.
Thanks,
Marcus.

Ps:
I know it's not a big deal...: first connection is slow, so what? Well: i am
having a hard time with laptops users complaining they must wait 2 mins
every time my app is run :((