On Sat, Aug 5, 2017 at 10:17 PM, iostream <sidds.mo...@gmail.com> wrote:

> Suppose I have 10 Person entries in the disk, out of which only 5 are
> in-memory. Now if I run a SQL query which is expected to count the number
> of
> entries in Person cache, will the query run only on the disk or RAM or will
> it run on both?

The SQL query will simply run over the total data set, which is 10 persons,
but it will obviously process the data that is cached in-memory faster. You
can also speed up SQL queries by indexing the data.

> If the query will run on both the disk and RAM, will the count be 10 or 15
> (10 on disk + 5 in RAM)? Does the SQL processor know which entries are
> present in-memory to resolve duplicates?
If I understand your example correctly, then the super-set of data is 10
Persons (right?). In this case, the total count returned by Ignite will be

> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Query-about-running-SQL-with-
> durable-memory-tp16015.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Reply via email to