ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexei Scherbakov <alexey.scherbak...@gmail.com>
Subject Re: off heap indexes - setSqlOnheapRowCacheSize - how does it improve efficiency ?
Date Mon, 23 May 2016 16:13:20 GMT
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