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 10. > > -- > 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. >