Connecting speed

[jhoehne]

Hello,

connecting to a database on the same machine via TCP/IP takes approx. 3 seconds. Is this a normal connection time?

I made a small test program, only nxRemoteServerEngine, nxWinsockTransport, nxSession, nxDatabase and nxQuery (but didn't open the Query, just set nxDatabase.Active := true). This took 3 seconds on a VM on a Xeon-1240v3 with a Samsung SSD as system and data drive.

--
Joachim

P.S.: if I close the connection and re-open, it's instantly.

How are you setting the servername? Is it an IP or a computer name?
Maybe the problem is the DNS server/settings.

HTH

--
Rodrigo G?mez [NDX]
M?xico, GMT-6

> connecting to a database on the same machine via TCP/IP takes approx.
> 3 seconds. Is this a normal connection time?
>
> I made a small test program, only nxRemoteServerEngine,
> nxWinsockTransport, nxSession, nxDatabase and nxQuery (but didn't open
> the Query, just set nxDatabase.Active := true). This took 3 seconds
> on a VM on a Xeon-1240v3 with a Samsung SSD as system and data drive.

If you are relying on the automatic broadcast discovery of the server,
instead of setting dns/IP address directly, then yes, the xeons and
SSDs won't make any difference.

You can adjust timeout properties on the transport, or use the actual
name/IP.

--
Eivind Bakkestuen [NDD]

[jhoehne]

Originally Posted by Eivind Bakkestuen [NDD]

> connecting to a database on the same machine via TCP/IP takes approx.
> 3 seconds. Is this a normal connection time?
>
> I made a small test program, only nxRemoteServerEngine,
> nxWinsockTransport, nxSession, nxDatabase and nxQuery (but didn't open
> the Query, just set nxDatabase.Active := true). This took 3 seconds
> on a VM on a Xeon-1240v3 with a Samsung SSD as system and data drive.

If you are relying on the automatic broadcast discovery of the server,
instead of setting dns/IP address directly, then yes, the xeons and
SSDs won't make any difference.

You can adjust timeout properties on the transport, or use the actual
name/IP.

--
Eivind Bakkestuen [NDD]

Ah! I've set only "ServerNameDesigntime" and thought this will be used at runtime too if I leave ""ServerNameRuntime" blank.
With "ServerNameRuntime" set to "NexusDB@127.0.0.1" too it takes only 22 msec.

Thank you!