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.
