Slow database-connection from Java

[anasiri]

Connecting from Java to rasdaman takes round about 2 seconds, while rasql has no such "delay".

Details here:
​https://groups.google.com/forum/#!topic/rasdaman-users/tEGrPxI4C9o

[anasiri]

Creates the test-data

[anasiri]

Reads the data using rasql

[anasiri]

Reads the same date using Java

[anasiri]

Sample program, which only makes a connection to the database.

[Dimitar Misev]

I'm getting ~450ms on my machine, which still seems quite high nevertheless.

[Dimitar Misev]

It's just the initial setup that takes a while. So for servers it should be no issue, for clients it's significant. Unfortunately I doubt we can improve much the "startup time", it's up to the network library we use.

Here are some measurements (I attached​ the code).

----------------------------------------------------
Starting test
Constructing RasImplementation: 19 ms
Mar 01, 2017 5:38:54 PM io.grpc.internal.TransportSet$1 run
INFO: Created transport io.grpc.netty.NettyClientTransport@47f6473(localhost/127.0.0.1:7001) for localhost/127.0.0.1:7001
Mar 01, 2017 5:38:54 PM io.grpc.internal.TransportSet$TransportListener transportReady
INFO: Transport io.grpc.netty.NettyClientTransport@47f6473(localhost/127.0.0.1:7001) for localhost/127.0.0.1:7001 is ready
Setting user identification: 347 ms
Creating Database: 0 ms
Mar 01, 2017 5:38:54 PM io.grpc.internal.TransportSet$1 run
INFO: Created transport io.grpc.netty.NettyClientTransport@6b53e23f(blade/127.0.1.1:9000) for blade/127.0.1.1:9000
Mar 01, 2017 5:38:54 PM io.grpc.internal.TransportSet$TransportListener transportReady
INFO: Transport io.grpc.netty.NettyClientTransport@6b53e23f(blade/127.0.1.1:9000) for blade/127.0.1.1:9000 is ready
Opening database: 80 ms

Creating Transaction 0: 0 ms
Begin Transaction 0: 3 ms
Commit Transaction 0: 14 ms

Creating Transaction 1: 0 ms
Begin Transaction 1: 8 ms
Commit Transaction 1: 18 ms

Creating Transaction 2: 0 ms
Begin Transaction 2: 9 ms
Commit Transaction 2: 16 ms

Creating Transaction 3: 0 ms
Begin Transaction 3: 6 ms
Commit Transaction 3: 15 ms

Creating Transaction 4: 0 ms
Begin Transaction 4: 6 ms
Commit Transaction 4: 14 ms

Creating Transaction 5: 0 ms
Begin Transaction 5: 6 ms
Commit Transaction 5: 14 ms

Creating Transaction 6: 0 ms
Begin Transaction 6: 5 ms
Commit Transaction 6: 14 ms

Creating Transaction 7: 0 ms
Begin Transaction 7: 5 ms
Commit Transaction 7: 15 ms

Creating Transaction 8: 0 ms
Begin Transaction 8: 7 ms
Commit Transaction 8: 16 ms

Creating Transaction 9: 0 ms
Begin Transaction 9: 7 ms
Commit Transaction 9: 16 ms
Mar 01, 2017 5:38:54 PM io.grpc.internal.TransportSet$TransportListener transportShutdown
INFO: Transport io.grpc.netty.NettyClientTransport@47f6473(localhost/127.0.0.1:7001) for localhost/127.0.0.1:7001 is being shutdown
Mar 01, 2017 5:38:54 PM io.grpc.internal.TransportSet$TransportListener transportShutdown
INFO: Transport io.grpc.netty.NettyClientTransport@6b53e23f(blade/127.0.1.1:9000) for blade/127.0.1.1:9000 is being shutdown
Total elapsed time: 708 ms
Test finished
----------------------------------------------------