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, 张馨匀 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