Subject | Re: 2 minutes and 40 seconds to connect to a 1GB database |
---|---|
Author | jeanpierre_planas |
Post date | 2005-10-16T21:59:40Z |
Hello
It's exact.
When i turn off system restore, all is ok...
Thank you very much for you help.
What i don't understand is why windows make a copy of the database
the first time the computer boots...
And why this database and not another ?
But this questions are Microsoft windows questions, and no more
firebird questions...
Thanks...
Jean-Pierre
--- In firebird-support@yahoogroups.com, "Stephen Boyd"
<sboydlns@y...> wrote:
It's exact.
When i turn off system restore, all is ok...
Thank you very much for you help.
What i don't understand is why windows make a copy of the database
the first time the computer boots...
And why this database and not another ?
But this questions are Microsoft windows questions, and no more
firebird questions...
Thanks...
Jean-Pierre
--- In firebird-support@yahoogroups.com, "Stephen Boyd"
<sboydlns@y...> wrote:
>of
> 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
> many different types of files (.GDB files among them) when they are<lester@l...>
> 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
> > 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.
> > >
> >
>