Subject Re: Depends on DB size, Connection becomes slow immediately.
Author Zoran Zivkovic
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...>
wrote:
>
> > Hi All,
> >
> > I am testing FirebirdSS as server under
Linux¡Êx86_64¡Ëenvironment.
> > Depends on DB size, Connection takes a lot of time.
> >
> > In case of 2GB, connection is instantaneous. But it takes 4 or 5
> > minutes in
> > case of 10GB.
> >
> > It seems that connection cause access to whole DB file in worst
case.
> > What's happening ?
> >
> > My environment in detail as below,
> >
> > [Server side]
> > Linux: FedoraCore4¡Êx86_64¡Ë
> > Firebird: FirebirdSS-2.0.0.12484-ReleaseCandidate3.amd64.tar.gz
> > CPU¡§Celeron(R) D Processor 336 (2.80GHz, 256KB L2 Cache, EM64T,
> > 533MHz FSB)
> > Memory: 512MB
> > HD¡§SATA
> >
> > [Client side]
> > OS: Windows2000SP4¡¢or WindowsXP SP2
> > Middleware: BCB5¡ÜBDE
> > CPU: Xeon3.6GHz
> > Memory: 4GB
> > HD: SATA
> > Regards,
> > KIMURA, Meiji(FAMILY, Given)
>
> something tell me that your reliance on BDE at this stage
(especially
> against FB2) is going to be a major issue for you.
> Also, you are testing against RC3 and 5 is out. If you are going to
test
> against release candidates, you are almost obliged to make sure
you have
> the latest before raising issues.
> Alan
>

I think, if you try to open all tables inside database with BDE
conection, it will be quite slow, especially if you try to reach end
of big tables (TTable.last;).
Alan, where is RC5 ?

Regards

Zoran Zivkovic