Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Interbase 6.5 Client is slow in network connection

99 views
Skip to first unread message

Bubola Federico

unread,
Nov 14, 2002, 5:50:53 PM11/14/02
to
Hi to all!

I have a problem with my delphi program using Interbase 6.5 client in
network connection to an IB 6.5 Server.
When i do an inizialize process with Interbase 6.0 client (free version) i
take 35 seconds, the same process with IB 6.5 client (using the same
machine, switch, etc.) take 3 minutes !!!!!
Why ????


Thanks to all.

Arno Brinkman

unread,
Nov 15, 2002, 5:53:13 AM11/15/02
to
Hi,

Are you using the gds32.dll that comes with IB6.5 ?
Don't mix the gds32.dll versions between other IB products.

Regards,
Arno


Frank Gruber

unread,
Nov 15, 2002, 8:47:22 AM11/15/02
to
> yes, I have completely unistall IB 6 free (uninstall IB 6, delete
gds32.dll
> and remove the InterBase directory).
> I've tried Firebird and the time for do the operation is 35 seconds (like
IB
> 6).
> I have install IB 6.5, following the installation notes, but the problem
> remaining,
> What can i do?

Post you connect string.
Do you connect via domain name or ip address ?
Seems to be a network issue maybe a name resolution
problem and not an ib issue.

Regards,
Frank.


Arno Brinkman

unread,
Nov 15, 2002, 8:31:17 AM11/15/02
to
Hi,

> yes, I have completely unistall IB 6 free (uninstall IB 6, delete gds32.dll
> and remove the InterBase directory).
> I've tried Firebird and the time for do the operation is 35 seconds (like IB
> 6).
> I have install IB 6.5, following the installation notes, but the problem
> remaining,
> What can i do?
>

> Thanks

If you're connecting with TCP/IP try to connect with the IP-adres instead of the name.

For example :

192.168.2.1:C:\Databases\test.gdb

Regards,
Arno


Bubola Federico

unread,
Nov 14, 2002, 6:32:39 PM11/14/02
to
Hi Arno,

yes, I have completely unistall IB 6 free (uninstall IB 6, delete gds32.dll
and remove the InterBase directory).
I've tried Firebird and the time for do the operation is 35 seconds (like IB
6).
I have install IB 6.5, following the installation notes, but the problem
remaining,
What can i do?

Thanks


"Arno Brinkman" <_fir...@abvisie.nl_> ha scritto nel messaggio
news:3dd4...@newsgroups.borland.com...

Craig Stuntz [TeamB]

unread,
Nov 15, 2002, 10:07:33 AM11/15/02
to
In article <3dd4...@newsgroups.borland.com>, HVFDMI...@spammotel.com
says...

> Post you connect string.
> Do you connect via domain name or ip address ?
>
Also, which OS for client and server?

-Craig

--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog: http://delphi.weblogs.com
InterBase PLANalyzer 1.1 out now (free IB optimization tool):
http://delphi.weblogs.com/IBPLANalyzer

Bubola Federico

unread,
Nov 15, 2002, 12:34:29 PM11/15/02
to
> Post you connect string.
> Do you connect via domain name or ip address ?
> Seems to be a network issue maybe a name resolution
> problem and not an ib issue.
>
> Regards,
> Frank.
>
>
My connection String is:
192.168.1.144:C:\Database\test.gdb

I've tried with name and ip address but the result is the same.
I don't think that is the name resolution problem because i've used the same
string for IB 6 free and IB 6.5.

Thanks,
Federico


Frank Gruber

unread,
Nov 18, 2002, 1:20:15 PM11/18/02
to
> My connection String is:
> 192.168.1.144:C:\Database\test.gdb

Ok no name resolution problem.

You said in your prev. post "When i do an inizialize process"
What exactly do you mean ? Just connecting to your db
or also open a query ? What happens if you connect
via IBConsole using the above connect string ?

Regards,
Frank.


@abvisie.nl Arno Brinkman

unread,
Dec 6, 2002, 5:37:22 AM12/6/02
to
Hi,

> With "Initialize process" I mean the time necessary for connecting to DB and
> open one query in a large table.
> If I try to connect using IBConsole the resulting time (for this two
> operation) is the same (3 min.)
> What can I try to do?

Fetching a lot of records in IB6.5 is much slower as in IB6-OE and Firebird.
That could explain it.
Fetch only the records you want, not the whole table.

Regards,
Arno

Craig Stuntz [TeamB]

unread,
Dec 6, 2002, 4:09:53 PM12/6/02
to
In article <3df07e30$1...@newsgroups.borland.com>, "Arno Brinkman"
<bnewsgroups @ abvisie.nl> says...

>
> Fetching a lot of records in IB6.5 is much slower as in IB6-OE and Firebird.
>
Hmmm? I've seen the opposite (probably due to character field
trimming).

-Craig

--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com

InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

@abvisie.nl Arno Brinkman

unread,
Dec 6, 2002, 5:38:09 PM12/6/02
to
Hi Craig,

> > Fetching a lot of records in IB6.5 is much slower as in IB6-OE and
Firebird.
> >
> Hmmm? I've seen the opposite (probably due to character field
> trimming).

Maybe, with large varChar's
I test many queries against serveral versions (IB6.0.1.6, IB6.0.2.0, IB6.5)
and saw that in most case fetching a lot of records ( > 8000) is much slower
on IB6.5. I must say that all the fields in the tables are NOT higher then
varChar(50) and contain data (partialy filled).

Regards,
Arno


0 new messages