ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vkulichenko <valentin.kuliche...@gmail.com>
Subject Re: Are SQL queries applicable to the data swapped to disk ?
Date Mon, 14 Mar 2016 23:03:36 GMT
Hi,

Can you please properly subscribe to the mailing list so that the community
receives email notifications? Follow the instruction here:
http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1


niksmv wrote
> Are SQL queries applicable to the data swapped to disk when
> data set exceeds the limits of on-heap and off-heap memory?

SQL query can read the data that is in swap space, but keep in mind that it
will have to unswap it (i.e., move into memory). Thus, if the result set is
large, the node can run out of memory. In general, you should avoid using
swap space because in many cases it's eliminating advantages of in-memory
processing. Is there any particular reason for having it in your case?

-Val



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Are-SQL-queries-applicable-to-the-data-swapped-to-disk-tp3473p3496.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message