RE: SQL performance very slow compared to KV in pure-in-memory cache?

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 января

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

Re: SQL performance very slow compared to KV in pure-in-memory cache?

As per my knowledge, results are quite obvious and expected, KV definitely gives better performance compared to SQL, since SQL (table) is wrapper built on top of cache. If you are looking for better performance than KV, you can even go for storing data in the binary form. if we store data in

Re: SQL performance very slow compared to KV in pure-in-memory cache?

Can anyone throw some light on this please? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/