I'm Fred and I'm testing voltdb.
I'm worried about connection time to voltdb cluster.
I use distant VMs and each machine have the same environement. I use one to run mysql and 3 others to run voltdb cluster.
I'm calculating time connection, so I run this command to know execution time from a client:
date +"%Y%m%d%H%M%S.%N" && echo "Select current_timestamp() from resources limit 1;" | sqlcmd --servers=serveur && date +"%Y%m%d%H%M%S.%N"
For Voltdb cluster, it spends 20ms to execute the command, but for the client this command spends 870ms. So there is 850ms used to connect to voltdb cluster? I find this delay very important. The ping between client and host is only 0.120ms.
When I try a similar test with mysql, it spends only 12ms for the client.
Is it normal to have a huge connection time? If it's not, what parameters have to be managed to decrease connection time?
thanks for your attention,