19 Nov
2009
19 Nov
'09
9:37 p.m.
Stefan and Martin, Thank you both for so much detail. I will have to consider a 64bit machine for future convenience. I have managed to import all my data by splitting the raw file into parts by rows. Much improved. I am now doing queries. I wonder now if there is a direct way to do percent rank of a column value by date? I understand how to make the calculation by I did not want to overlook a simple answer with MonetDB. My experience has been with Oracle functions like percent_rank and lag/lead for example. Again thank you all for starting me off. My initial test query are performing very fast and I'm excited about MonetDB's success. Thanks. Paul