Subject RES: [firebird-support] 2 minutes and 40 seconds to connect to a 1GB database
Author Andre Fogelman
Is your database running on a win XP and the database name ends with
If that is the case change the name to *.fdb that your problem will be
solved. GDB files are included in the restore function of the operating

-----Mensagem original-----
[] Em nome de jeanpierre_planas
Enviada em: domingo, 16 de outubro de 2005 09:48
Assunto: [firebird-support] 2 minutes and 40 seconds to connect to a 1GB


I have a big database from a customer. (About 1 GB).
The problem i have is when i startup my computer and i
open this database i wait more than 160 seconds (2
minutes and 40 seconds)
before the database is connected with IBOConsole or
any other program.
My database is valid (I make a backup/restore...)
This problem appears only the first time i want to
connect to my database.

My computer is fast (P4, 2GHz, 1GB of RAM).

If i open another database before (a 12 MB database for
example), i don't need to wait when connecting to my
1GB database.

Another information : I see that before connecting to my
1GB database, in taskmgr, i have fbserver.exe that
make 1GB of I/O Write.
I don't know why fbserver makes so make writes, but it
could explain why it's so long to connect...