Subject | 2 minutes and 40 seconds to connect to a 1GB database |
---|---|
Author | jeanpierre_planas |
Post date | 2005-10-16T11:47:44Z |
Hello
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...
If you need the database, i can put it on a ftp server, and
you can download it...
I use lastest RC version : 1.5.4731
I don't use firebird as service.
Fbserver.exe is run when my PC boots...
I have Post a Bug (http://sourceforge.net/tracker/index.php?
func=detail&aid=1327678&group_id=9028&atid=109028) but it was closed
saying that it's in this mailing list that i could find the
solution...
Some can help me please ?
Jean-Pierre
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...
If you need the database, i can put it on a ftp server, and
you can download it...
I use lastest RC version : 1.5.4731
I don't use firebird as service.
Fbserver.exe is run when my PC boots...
I have Post a Bug (http://sourceforge.net/tracker/index.php?
func=detail&aid=1327678&group_id=9028&atid=109028) but it was closed
saying that it's in this mailing list that i could find the
solution...
Some can help me please ?
Jean-Pierre