Hello All,

We are evaluating monetdb for use as a tick database. We are storing all the data into a single table. Our table has a column for timestamp and a few other fields. We wish to run queries against it, the most useful of which is to return all entries within a given timestamp range. This query takes a long time to execute for even a 15 minute interval (about 40 to 60 seconds). We have noted that the system RAM usage goes up to the maximum (almost 8GB) while we run such queries on monetdb. We wanted to understand whether installing more RAM (say, we upgrade to 16 GB) will result in a significant performance improvement for such queries on monetdb.

Also, if this is the case, we would like to know, how much RAM is monetdb optimised for?

The following is the specification of our server:

Intel Xeon X3430 2.4Ghz

64Bit

8Gb Ram

500Gb HDD - Raid0

Running on Windows Server 2008 R2.

We are using the 20130212 build of monetdb.

Thank you,

Anshuman