Hi Swapnil, the public production release of MonetDB does not do any SQL result caching. Best, Stefan On Fri, Nov 30, 2012 at 11:44:57AM +0530, swapnil joshi wrote:

Hi,

Is there monetdb maintain any SQL result cache. If yes, then How and where is it maintain? and If no then how he will get millions of rows result in millisecond.

My System configuration is as follow : Hardware = Processor : Intel i7 2.3 GHz, RAM DDR3 8GB, HD 1 TB, OS = Ubuntu 12.04

I am new in IT world and i am doing some research on Monetdb. I have created my own user define function but it's result is not cached, every time it is doing operation on data and it take some in milli seconds.

Please tell me about monetdb cacheing policy

Can you give me some guide line?

-- Regards, Swapnil K. Joshi

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list