Subject Re: 2 minutes and 40 seconds to connect to a 1GB database
Author Stephen Boyd
Try changing the extension on the database path to .FDB or turn off
system restore. If system restore is enabled XP will take a copy of
many different types of files (.GDB files among them) when they are
modified. This is probably what is causing the slow connect times.


--- In firebird-support@yahoogroups.com, "jeanpierre_planas"
<jeanpierre_planas@y...> wrote:
>
> > 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.
> >
>