Hi, no, MonetDB/SQL does not provide any means to explicitly load data from disk into memory. If you need that, e.g., after a server restart to get data "hot" before the first user query runs, you could of course run some queries that touch (only) the data you want to make "hot". Suitable example include simple (global) aggregates over each coulm you want to make hot. min() & max() are fine (i.e, perform a sequential scan) for columns that are not sorted --- if MonetDB know (after bulkload) that a column is sorted, min() and max() obviously need to touch only the first and last value, respectively. For sorted numerical columns, sum() is a suitable alternative. Hope this helps you further, Stefan On Thu, Jul 08, 2010 at 03:39:27AM -0700, 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. -- View this message in context: http://old.nabble.com/Loading-directly-into-memory.-tp29105569p29105569.html Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |