Running the query the first time isn’t really like loading all data into memory and then doing the query. I would assume that it is much less efficient – all kinds of locking and contention may be involved. Also, the reads are done via random disk access, while when reading from CSV you’re reading sequentially.
I assume that there are ways to make queries on a cold storage more efficient. One would probably need to spend a lot of time on that collecting and analyzing JFRs and other profiling data. On the other hand, having an ability to do a hot restart will probably solve the issue for most users. Stan From: gweiske Sent: 11 января 2019 г. 2:03 To: user@ignite.apache.org Subject: RE: Ignite 2.7 Persistence Thanks for the replies. Yes, subsequent queries are faster, but the time to run the query the first time (i.e. load the data into memory) after a restart can be measured in hours and is significantly longer than loading the data from a csv file. That does not seem right. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/