Are SQL queries applicable to the data swapped to disk ?

classic Classic list List threaded Threaded
2 messages Options
niksmv niksmv
Reply | Threaded
Open this post in threaded view
|

Are SQL queries applicable to the data swapped to disk ?

This post has NOT been accepted by the mailing list yet.
Are SQL queries applicable to the data swapped to disk when
data set exceeds the limits of on-heap and off-heap memory?
vkulichenko vkulichenko
Reply | Threaded
Open this post in threaded view
|

Re: Are SQL queries applicable to the data swapped to disk ?

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