Hi, Generally speaking, settings setSqlOnheapRowCacheSize to larger value increases SQL performance in OFFHEAP_TIERED mode, but also means more job for GC, so it should be used with care.
The value should be set to the size of your application's working(frequently accessed) data set. 2016-05-23 13:07 GMT+03:00 vkulichenko <valentin.kuliche...@gmail.com>: > Are you using offheap? What is your data size? > > Generally, I would recommend to use on-heap with SQL queries if this > possible (unless you have a very big data sets and want to avoid having > large heap sizes). If you still have to use offheap, you can try playing > with this parameter and see what performance you get with different values. > The optimal value depends on a particular application. > > -Val > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/off-heap-indexes-setSqlOnheapRowCacheSize-how-does-it-improve-efficiency-tp5070p5092.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Alexei Scherbakov
