I do have seen this problem on JDBC, with mclient same query takes 10 secs less. I am not sure why it is happening as from SQL Workbench teh connection should be persistent and it should not connect again on every query.

Does anybody have similar experiences with ODBC & PHP ?? Just wondering how it behaves in that case.

Thanks

On Tue, Apr 21, 2015 at 9:01 AM, Robert Koch gms_xy@gmx.de wrote:

Hi all,

I'm using DBVisualizer to connect via JDBC to MonetDB. There is a delay of very exactly 10 seconds during the connection process. This only happens via JDBC. There are no DNS issues, since the connection is done via IP directly. Connection from the commandline of the server with mclient works perfectly. First step to get closer was to inspect the output of tcpdump. It seems to be on the side of MonetDB, since the last packet is the one sent to MonetDB (192.168.56.102) from my Windows Client (192.168.56.1).

09:33:24.663824 IP 192.168.56.1.57271 > 192.168.56.102.50000: Flags [.], ack 1, win 256, length 0 --- 10 soconds 09:33:34.676884 IP 192.168.56.102.50000 > 192.168.56.1.57271: Flags [P.], seq 1:3, ack 1, win 229, length 2

Additionally, DBVis ist connecting speedy with other databases (PostgreSQL) on the same server.

Using following version: MonetDB 11.19.9 MonetDB Native Driver 2.14 (Liberica 20150123 based on MCL v1.11)

I did not experience this problem in former versions of MonetDB.

Any idea?

Thank you. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list