Subject Re: [ib-support] Re: Slow
Author Gerhard Knapp
hi helen,
thank you, good to hear ...
then i make something wrong ..
i am not happy to write about a bug, i only replied to a message here,
with the same problem ...


no IPX/SX no other protocols, i have poor TCP
TCP transport is rush, 100Mbit/sec, Cisco Switches, fast network ...

Yes 2 processors, i tried all Affinity settings, my best result is with
CPU_AFFINITY = 0 in ibconfig,
if i use CPU_AFFINITY = 1 or 2 then one of the processors is going often to
i used also the standard ibconfig, its the same with the connecting
then i give the database and FB1 to another computer (Athlon 1600 XP
single, -> same connecting problem

i see some things i don't understand, i have 256 MB mem but FB doesn' use
i have 40 clients on this server ..
if running FB on one CPU this is going to 100% if 3 or 4 connecting at the
same time ...
i hope you don't missunderstand me, the connecting problem is the same,
also if one 1 user is working and will connect ...

3. the server is only for FB1, nothing else, no fileserver ... and so on...
for support another application is VNC what i use sometimes ...

4. i don't use tables, i use only querys, and they are all closed,
if the application is starting

5. WITH OLDER BDE-Applications its not a problem, connecting
has allways nearly the same time: 3 seconds
(i tried it now, i will find, what i make wrong ...)

6. i only use the standard values from the IBODatabase,
and set server, database and charset, thats all, then i connect ...


at least:
i am a great fan of FB, but i will solve my problem with the connecting ...


----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <>
Sent: Tuesday, June 11, 2002 6:02 PM
Subject: Re: [ib-support] Re: Slow connection..It's a bug......

> At 04:57 PM 11-06-02 +0200, you wrote:
> >hello,
> >i have the same problem, its horrible ....
> >
> >A connection to the firebird 1.0 database can need 10 seconds, only the
> >connect!
> >i have a user named p.e.: xuser, and all my clients connect with xuser
> >his password ...
> >i use: IBODatabase
> >
> >with following:
> >
> >CharSet = WIN1252
> >server = xserver
> >path = d:\xxxxx.gdb
> >pagesize = 8192 (the same, as the db is created)
> >
> >the rest is standard, as IBOdatabse it gives ....
> >then the time between: database.connected:= true, and the result could
> >from
> >2 till more as 10 seconds, this is very courisoly ...
> >
> >(in the beta 2 Firebird release (last before 1.0) i don't have this
> I don't believe this "Slow connection...It's a bug..." thing. I've
> **never** observed it, not in IB 5.6, not in IB 6.x, nor in any of the
> Firebird builds. The issue I'm aware of with the IB local client on
> Windows is that it's not thread-safe.
> Using the following setups I have sub-second connection speeds in all
> with Firebird 1.0. The Windows server is NT SP 6a running on a slowish
> Celeron (434 MHz, 384Mb), the Linux server is RedHat 7.2 on a 850Mhz AMD
> Duron, 512 Mb.
> 1. Delphi application using TIBODatabase, local connection (protocol
> cpLocal, path y:\gdb_6\ibobase\ibobase.gdb)
> 2. Same application using TIBODatabase in Kylix, connecting with cpTCP_IP
> to localhost:/data/ibobase/ibobase.gdb (copy of same database running on
> 3. IB_SQL (uses native IBO IB_Connection) connecting to local server by
> local loopback, cpTCP_IP, path dev:y:\gdb_6\ibobase\ibobase.gdb
> 4. Another instance of same, simultaneously.
> 5 and 6, two more instances of 3 & 4, this time with localhost as server.
> And the same across the network in either direction - IBO-Kylix client to
> Windows server, Windows client to Linux server.
> There's nothing special about these server setups, except that I have
> of temp space configured; and the NT machine has two large chunks of
> pagfile.sys configured on separate physical disks. I have SMB running on
> the Linux box for convenience, although I wouldn't do that under
> conditions. Looking at my NT taskbar right now, I have two large WinHelp
> files open, I'm running Delphi 6, Eudora, I'm connected to my dialup ISP,
> have 4 instances of IB_SQL, MSN Messenger and a graphics program.
> I'm sure you guys are looking at configuration and/or environment problems
> - or maybe your servers just don't have enough "grunt" to take all those
> instances of gds32.dll, local or loopback client connections competing
> the server and the database cache for resources.
> Also, make sure you have zapped IPX/SX from your protocol stack.
> Are there any multi-processors involved? Is your database server serving
> other applications?
> If you are using IBO, do you have GetServerDefaults or schema caching
> activated? That will slow down the initial connection (or the only
> connection, if it is one connection per client), since that involves
> network traffic and/or disk i/o, before the connection makes itself
> to the actual application.
> If you are using a lot of table components for your applications and are
> opening them all in your FormCreate, then that will dog your connection
> time, too.
> heLen
> All for Open and Open for All
> Firebird Open SQL Database · ·
> _______________________________________________________
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to