Subject Re: 2 minutes and 40 seconds to connect to a 1GB database
Author jeanpierre_planas
> Which version of WIndows?

Windows XP SP2

> Where does it get it's IP addresses?

It's a local database. No need of IP adress.

> How do you connect to the database - connection string?

On IBOConsole, it's "d:\timeless\Test\Base\COLOMBUS_65_ORCH3.GDB"
D:\ is my hard disk...

For information, we are 4 developers to have this problems on 4
different PC (and a customer that have also the problem...)

If you want i can put the database on a FTP, and you can test
yourself...

--- In firebird-support@yahoogroups.com, Lester Caine <lester@l...>
wrote:
>
> jeanpierre_planas wrote:
>
> > 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 ?
>
> Which version of WIndows?
> Where does it get it's IP addresses?
> How do you connect to the database - connection string?
>
> Time you are quoting is nothing unusual for a badly set up network -

> which is why it's probably not a bug ;)
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
> Treasurer - Firebird Foundation Inc.
>