Re: SQL_NO_CACHE equivalent?

On 30/10/14 19:05, Vijay Krishna wrote:

Hi,

Is there any equivalent to SQL_NO_CACHE in monetdb??

I wish the queries I run to return results from disk in order to check performance.

No. Memory residency of database columns is OS dependent. See:https://www.monetdb.org/Documentation/MemoryClaim

Forcing disk analysis calls for 1) stopping the mserver 2) cleaning of the file system cache (OS dependent) 3) start server and run query once.

regards, Martin

Any help much appreciated. Thanks in advance.

With Regards,

Vijayakrishna.P. Mobile : (+91) 9500402305.

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list