Hi Naveen, You can try a 'lazy' flag for query. It is available from ignite-2.4 that has been released recently. See SqlFieldQuery javadoc [1] and JDBC doc [2] for details.
[1] https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/cache/query/SqlFieldsQuery.html#setLazy-boolean- [2] https://apacheignite-sql.readme.io/docs/jdbc-client-driver On Thu, Mar 29, 2018 at 8:57 AM, Naveen <[email protected]> wrote: > Hi > > I am using ignite 2.3 with native persistence layer as backing store > > We do have close to half to 1 billion records in each of the tables. > > There are some adhoc requirements to query the tables with diffrent where > conditions, columns which we use in where clause may not have indexes, > which > may take time to execute the query, but it should slow the down or crash > the > cluster. We are not using eviction, all our data is residing in RAM. > > My question is - shall we have any means to run the queries directly on > persistence store instead of on RAM, so that whatever queries we run will > not impact cluster ?? > > Hope you understood my requirement ? > > Thanks > Naveen > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ > -- Best regards, Andrey V. Mashenkov
