Do you use the same config for both runs? If you use ignite-sql.xml for SQL and ignite.xml for key-value than key-value keys indeed should be much faster, because SQL features are not used there and Ignite doesn’t have to maintain all the SQL indexes, etc.
Stan From: summasumma Sent: 7 января 2019 г. 12:24 To: user@ignite.apache.org Subject: Re: SQL performance very slow compared to KV in pure-in-memory cache? Thanks Naveen. I am definitely not looking for better performance in SQL than KV store. But just wanted to know if the results im getting in scale of 1:4 performance between SQL and KV store is as expected or not, say a particular operations give 400k ops in KV but same size records with same operations gives only 100k ops in SQL. Furthermore, is there any performance tuning which we can do to improve the SQL performance slightly? Note: i have tried sqlOnheapCacheEnabled in cache configuration, but still performance didn't improve. Thanks, ...summa -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/