Subject RE: [firebird-support] Depends on DB size, Connection becomes slow immediately.
Author Alan McDonald
> 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