Hi, I have been testing MonetDB for quite a while and I am a bit quizzed by its RAM utilisation. I tested MonetDB with some complex data and queries as per my requirement in 2 machines - *one with 16 GB RAM and the other with 128 GB RAM *with no memory restrictions for applications. There are no applications other than MySQL and MonetDB running in those machines. The puzzling part was *all the queries took the same time with both the machines*. I have read quite a few documentations wherein I found that the MonetDB performance heavily depends upon RAM memory available. What am I missing? Any help much appreciated. Thanks & Regards, Vijayakrishna.P. Mobile : (+91) 9500402305.
Hi, if all your ("hot"; cf [1]) data fits in the RAM of your smaller machine (16 GB), more memory (128 GB) in your larger machine will (can) not speed up query processing, assuming that otherwise (OS, CPU, I/O subsystem) both machines are identical. Best, Stefan [1] https://www.monetdb.org/Documentation/MemoryClaim ----- Original Message -----
Hi,
I have been testing MonetDB for quite a while and I am a bit quizzed by its RAM utilisation.
I tested MonetDB with some complex data and queries as per my requirement in 2 machines - one with 16 GB RAM and the other with 128 GB RAM with no memory restrictions for applications. There are no applications other than MySQL and MonetDB running in those machines.
The puzzling part was all the queries took the same time with both the machines .
I have read quite a few documentations wherein I found that the MonetDB performance heavily depends upon RAM memory available.
What am I missing? Any help much appreciated.
Thanks & Regards,
Vijayakrishna.P. Mobile : (+91) 9500402305.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
participants (2)
-
Stefan Manegold
-
Vijay Krishna