Hi, The count should be 15. If a page is not found in RAM, then the durable memory will request it from the Persistent Store. Please check https://apacheignite.readme.io/v2.1/docs/distributed-persistent-store#section-usage
Are you observing a different behavior? Kind regards, Alex. On Sun, Aug 6, 2017 at 8:17 AM, iostream [via Apache Ignite Users] < ml+s70518n16015...@n6.nabble.com> wrote: > Hi, > > I want to understand how SQL queries work when persistence store is > enabled in v2.1. > > 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? > > 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? > > Thanks! > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > http://apache-ignite-users.70518.x6.nabble.com/Query- > about-running-SQL-with-durable-memory-tp16015.html > To start a new topic under Apache Ignite Users, email > ml+s70518n1...@n6.nabble.com > To unsubscribe from Apache Ignite Users, click here > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=YWxleGFuZGVyLmZlZG90b2ZmQGdtYWlsLmNvbXwxfC0xMzYxNTU0NTg=> > . > NAML > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-about-running-SQL-with-durable-memory-tp16015p16031.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.