Subject Re: [firebird-support] Windows 2003 and Interbase 5.5 connection problem.
Author Helen Borrie
At 12:05 PM 16/10/2003 +0200, you wrote:
>Good day
>\=-\=\=-\=-\-=
>
>I have scanned the list for answers on this question and applied the
>suggestions, but we cannot seem to get
>rid of this problem
>
>We have a client with a new server Pentium 4 and Windows 2003.
>
>We have disabled Shadow copies.
>
>We have optimized CPU and memory for Programs
>
>But connections to the Interbase SERVER is extremely slow. For example :
>User Server Manager ON the server
>and connecting the server takes 12 seconds, connecting to the database
>takes 11 seconds.
>
>A funny is that working with the database AFTER connecting is fast and
>fine. It is just the connection that seems to be the problem.
>It also is not only the FIRST time connecting that is the problem it is the
>same over and over again, so it is not a cache problem for the
>first connection.
>
>Out application is using BDE writing in Delphi 3. The network protocol
>loaded on the Server is TCP/IP and also on the clients.
>
>The Interbase version is 5.6.
>
>Some of the clients are Win95 and also looses the network now and again.
>
>Thanks for any help or suggestions.

I guess you are aware that you have to set the CPU affinity for one
CPU? You can get a software tool for this, but it does mean you have to
run the server as an application.

It could be just that the BDE doesn't work well on Win2003. Borland
deprecated the BDE after Delphi 5 and the half-hearted "upgrade" that
shipped with Delphi 6 was ...erm... not a bucket of thrills. The Delphi 3
BDE version is ancient - one of the very early 32-bit versions.

Have you tried connecting remotely using isql? (not WISQL, but
command-line isql). It doesn't use the BDE, so at least you could
establish whether it's the BDE that's your problem.

heLen