Ok, I am going to use OFF_HEAP.
On each node I am going to use about 10 GB. (My ram is 16GB). Can you help me adjust configuration for this aim ? It is very important for me. Aim: Extremely fast sql quries. 2016-05-23 18:13 GMT+02:00 Alexei Scherbakov <[email protected]>: > 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 <[email protected]>: > >> 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 >
