Any idea on this issue? Btw, I am currently building a MonetDB profile for DBVisualizer, in order to have support for many features of MonetDB. After each change I have to do a reconnect. Waiting 10 seconds each time is horrible.
 
Thanks
 
Gesendet: Dienstag, 21. April 2015 um 11:26 Uhr
Von: "shamsul hassan" <shamsulbuddy@gmail.com>
An: "Communication channel for MonetDB users" <users-list@monetdb.org>
Betreff: Re: Exactly 10 Seconds Delay during JDBC connect to MonetDB
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.
 
Thank you.
 
 
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
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list