Re: sql query large data set which is larger than memory

2016-07-12 Thread vkulichenko
ll not run out of memory. But generally using swap space is a bad practice. If you don't have enough RAM, it's better to add it, otherwise you lose much of Ignite advantages. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/sql-query-large-data-set-

Re: sql query large data set which is larger than memory

2016-07-12 Thread November
off-heap memory is also in RAM. The data set is larger than RAM. If it's possible to put cache in swap space and do sql operations while some cache data store in swap space? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/sql-query-large-data-set-whi

Re: sql query large data set which is larger than memory

2016-07-12 Thread AndreyVel
HI November, Please look at memory parameters JVM_OPTS for server nodes. Try to use off-heap memory for cache [1] [1] http://apacheignite.gridgain.org/v1.5-b1/docs/off-heap-memory -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/sql-query-large-data-set-which

sql query large data set which is larger than memory

2016-07-11 Thread November
{ Name = CacheName, EnableSwap = true }); -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/sql-query-large-data-set-which-is-larger-than-memory-tp6219.html Sent from the Apache Ignite Users mailing list