Hi,
I was trying to benchmark ignite for with YCSB in both KV and SQL model.
Ignite is 2 node cluster with 4CPU and 24GB ram and capable 10Gig n/w cards.
Persistance=false(disabled) and backup=1
With this setup, when i ran ycsb for insert and read operations i get
following:
1) 100% insert performance:
KV Store ---> 150k ops
SQL ---> 50k ops
2) 100% read performance:
KV Store ---> 430k ops
SQL --->142k ops
Can i know if these numbers are expected in ignite? why is SQL performance
almost 1/3rd of KV performance?
Is there anything/configuration etc can boost the performance for sql?
(note: i just tried key_index using xml config: <bean
class="org.apache.ignite.cache.QueryIndex">
<constructor-arg value="actual_key"/> which
infact degraded insert operation a little)
This is my ignite configuration:
ignite-sql.xml
<http://apache-ignite-users.70518.x6.nabble.com/file/t2137/ignite-sql.xml>
Any help highly appreciated.
Thanks,
...summa
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
