Hi all,
Do you have any idea about the query throughput regarding monetdb cluster, is it slow?
I created the monetdb cluster using remote table, when I do query, it's really slow, about 3sec/query.
Do you know how to improve this? Or MonetDB can actually do better than this? And How?
Thank you
Hi,
given the provided information and problem description, I can only say that MonetDB works superbly and lightning fast for me both on a single machine and any cluster size I used so far.
Best, Stefan
----- On Feb 28, 2017, at 5:22 PM, 张馨匀 zhangxinyun91@gmail.com wrote:
Hi all,
Do you have any idea about the query throughput regarding monetdb cluster, is it slow?
I created the monetdb cluster using remote table, when I do query, it's really slow, about 3sec/query.
Do you know how to improve this? Or MonetDB can actually do better than this? And How?
Thank you
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hello Xingyun,
To help us to help you, we need to know at least:
- what hardware do you use: CPU, MEM, storage? how are they connected? - which OS? - which MonetDB version? Which configuration options did you use to compile it? - what is the size of your cluster? - how many MonetDB instances are you running? - do you run MonetDB in virtual machines or on bare-bone hardware? - how do you run each MonetDB instances: one instance per VM, multiple instance per VM, one instance per hardware server, or multiple instance per hardware server? - are the VMs or hardware servers shared with other users? - how does your MonetDB client connect to the MonetDB server? what’s the speed of the connection? - how much data are you using? - how many remote tables do you have? how much data do you have per remote table? - what is the schema of your table? - what are the queries you have run? what’s their result sizes? - how did you measure the number of “3sec/query”: puur query execution time on the server? or does it include the client-server communication time? is it a one time measurement or average of multiple runs? is it time of cold or hot run(s)?
Regards, Jennie
On 28 Feb 2017, at 17:22, 张馨匀 zhangxinyun91@gmail.com wrote:
Hi all,
Do you have any idea about the query throughput regarding monetdb cluster, is it slow?
I created the monetdb cluster using remote table, when I do query, it's really slow, about 3sec/query.
Do you know how to improve this? Or MonetDB can actually do better than this? And How?
Thank you _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Stefan Manegold
-
Ying Zhang
-
张馨匀