In addition to Ilya's response, if you can't fit all the data in-memory then turn on Ignite native persistence. Our SQL engine queries data both memory only and disk datasets. Plus, you don't need to warm up RAM after restarts with the persistence.
- Denis On Tue, Apr 2, 2019 at 6:14 AM Ilya Kasnacheev <[email protected]> wrote: > Hello! > > Read Through only works when reading by id. It will not work with SQL. You > need to have all data in Ignite before you can run SQL queries on the whole > dataset. > > Regards, > -- > Ilya Kasnacheev > > > пн, 1 апр. 2019 г. в 19:40, himanshu <[email protected]>: > >> Hello Gurus, >> >> I have 2 tables Person and Contact , contact table has person id as >> foreign >> key. >> I have loaded 200k records in database and I am trying to test read >> through >> with this data set using spring ignite data module. >> >> when I am calling repository.get(primaryKey) it is able to load that >> object >> in memory but when I try the same with another attribute in person table >> which is annotated with QuerySqlField annotation it is not working. >> >> when I have loaded all data in memory it is working fine but that is not >> read through scenario since I have all data in memory? >> >> any help is appreciated >> >> >> >> -- >> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >> >
