hello,
I am having performance degradation issues with repeated queries of
monetdb. I am attempting to use monetdb for financial tick data and make sql
queries requesting all quotes for a symbol on date x where time > y and time
<z. Previously monetdb had worked great for this task and was extremely
quick. However, I had a crash last week of the server it was built on.
After this monetdb ran incredibly slow on the order of 25 times slower than
it was running before. I rebuilt monetdb and it ran quickly for a day or
two and started degrading in speed. Could someone give a hint or two on how
I should go about debugging this? Is there a optimization task that I need
to run?
I am really at a loss of how I should handle this. I have been running
queries via mclient -s from my program written in python. I previously
found the python bindings too slow.
Stats:
cpu: 2 opteron 2222
os:cent os 5.4
memory 8gb
database Size: only testing with csv data of 1.3 GB indexed by date and
time
built with options:--enable-optimise --enable-sql
Thanks for any help,
Michael