Lets assume we have a CQ query set up with a server. We not interested in executeWithInitialResults, hence starting it mechanism "CqQuery.execute".
For e.g. --> CQ being " Select * from /Trade where price > 100 "
So when we start CQ , we see this query executed on server side and all data satisfying condition is loaded in memory.
Is this expected behaviour from geode ?
We were under impression that as we are not interested in initial data set , this query would not be executed and only new events would be transferred to the listener. Are we wrong with this assumption ?
Also We have kept our subscription to durable for 10 hour.
Now what we notice is, if server restarts ( client still active ), the CQ query is executed again on server side post restart.
This re-populates all the data in memory.
Again is this expected way for CQ to work in geode?