ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tomek W <rrrtomtom...@gmail.com>
Subject Re: off heap indexes - setSqlOnheapRowCacheSize - how does it improve efficiency ?
Date Mon, 23 May 2016 19:05:26 GMT
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 <alexey.scherbakoff@gmail.com>:

> 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.kulichenko@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
>

Mime
View raw message