Nozhup wrote:
Hi,
The first query after a load action takes longer because the new data is still 'cold'. Is there a way in MonetDB to load data directly with a 'hot' status?
Thank in advance.
So, assuming you are on a Unix platform, there are some pretty simple and effective ways to efficiently do this. The simples is to have a program that touches (read one byte) each page of the index file (typically every 4K in Linux) to force it to paged in to the FS cache (actually, this trick works pretty well on non-Unix platforms as well). For best efficiency, write a program that memory maps the file, then uses mlock() to force it in to RAM, and then exits. --Chris -- View this message in context: http://old.nabble.com/Loading-directly-into-memory.-tp29105569p29315232.html Sent from the monetdb-users mailing list archive at Nabble.com.