Sergy, point taken, but what i'm trying to point out is the following... In on-heap mode I can easily insert and query 0-15,000,000 without any performance loss. And if anything even more then 15 million entries in the cache.
The off-heap cache though instantly within a few thousand entries it's performance starts to degrade. Also for on-heap the query latency time stays consistent. So 1 entry or 15 million entries the query takes about the same time. This is not true for the off-heap it slowly degrades. To be clear we are talking about SQL queries and indexes. I posted my analysis in the threads above + the github code to reproduce it. I'm willing to even do a join.me to show you. I can reproduce it 100% of the time. Thanks -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Performance-indexing-performance-on-heap-vs-off-heap-tp1352p1419.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
