Hi Val, If " SQL queries only data that is already in memory ", what is the purpose of setReadThrough(true) in the cache configuration settings? I thought the cache would load data automatically, if no exist in the cache.
Regards, Kevin -----邮件原件----- 发件人: vkulichenko [mailto:[email protected]] 发送时间: 2016年4月14日 5:24 收件人: [email protected] 主题: Re: querying, sql performance of apache ignite Hi, 1. This is correct, current implementation of SQL queries only data that is already in memory. This is enough for majority of use cases, because usually in-memory systems deal with operational data sets (i.e. subsets of "hot", most frequently accessed data) and can safely ignore the rest of the data. For example, you can maintain the data for the last several days and discard historical data. If you have a different case, let us know. 2. IgniteCache is a key-value storage, but it's up to you how to map objects to relational tables. This is fully defined by CacheStore interface [1] and you can always provide your own implementation. Also take a look at [2] for information about bulk loading the data. There are more efficient ways then using get() method. [1] https://apacheignite.readme.io/docs/persistent-store [2] https://apacheignite.readme.io/docs/data-loading -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/querying-sql-performance-of-apache-ignite-tp4135p4143.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
