Fwd: Enhance Performance
I am bench-marking monetDB against some other databases. I have a system with intel i-7 processor, 32GB Ram and 2 TB Harddisk on a Ubuntu 12.10 system. I have a data work load of 700 GB in monetdb now. How can i enhance the performance and speed up the querying process. Any Suggestions would we welcome and please reply in detail. I am a newbie to Monetdb. Arjun Data Scientist -- Arjun Harish Nadh Data Scientist Flutura Business Solutions Pvt. Ltd. +919972736428 arjun.harish@fluturasolutions.com _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Dear Arjun That is a very generic question, which does not have easy answers without a clear indication of the target application or query patterns you have in mind. The bottom line is that MonetDB would not provide you 'tuning knobs' except for making sure you have compiled your code with --disable-debug --enable-optimize --enable-strict --disable-assert To understand the impact of your query expressions, you can have a look at the EXPLAIN and TRACE calls, which might indicate where your query semantically can be improved. success, Martin On 12/27/12 9:10 AM, Arjun Harish wrote:
I am bench-marking monetDB against some other databases. I have a system with intel i-7 processor, 32GB Ram and 2 TB Harddisk on a Ubuntu 12.10 system. I have a data work load of 700 GB in monetdb now. How can i enhance the performance and speed up the querying process. Any Suggestions would we welcome and please reply in detail. I am a newbie to Monetdb.
Arjun Data Scientist
-- Arjun Harish Nadh Data Scientist Flutura Business Solutions Pvt. Ltd. +919972736428 arjun.harish@fluturasolutions.com mailto:arjun.harish@fluturasolutions.com
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Arjun Harish
-
Martin Kersten