ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergi Vladykin <sergi.vlady...@gmail.com>
Subject Re: Local Node Query Optimization
Date Thu, 20 Aug 2015 10:48:54 GMT
If offheap is enabled (setOffheapMaxMemory is not -1) then SQL indexes are
always offheap. Setting setSqlOnheapRowCacheSize is the only way to put
part of your indexed in offheap data on heap to improve performance.

If you set setSqlOnheapRowCacheSize larger than the size of your dataset
then effectively you will have all your data on heap and better to disable
offheap at all.


2015-08-20 12:03 GMT+03:00 JohnnyS <jtksai@gmail.com>:

> I've set off_heap to 10 gigabytes for the test data. In production I
> probably
> need to load hundreds of gigabytes to the cache. I might have to use also
> swap space. For queries I need to keep the indexes in heap. Is there any
> other way to force this behavior besides using setSqlOnheapRowCacheSize?
> Regards,
> j.
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Local-Node-Query-Optimization-tp996p1075.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.

View raw message