Hi, Your results seem really strange to me - offheap behaves like onheap when there is not enough memory. Can you double check that proper configuration is used for different tests? You should probably use createCache() method instead of getOrCreateCache() to make sure that new cache is always created for new configuration. I would also use VisualVM or other tool to see what happens with memory utilization.
Generally queries can be around 20% slower with offheap due to a lot of index lookups, but 3 times performance loss looks suspicious. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Performance-indexing-performance-on-heap-vs-off-heap-tp1352p1353.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
