Hi,
When I tried running few db lookup scenarios in H2 and ignite, I got better
performance for H2. All were basic db operations like =, <=, >=.
These were the figures for 2million records(2 lookups for one record)
H2 : 3 minutes
Ignite (cache gets based on keys) : 3.4 minutes
Ignite (SQLFields query based) : 5 minutes
Below is my sample cache config:
cacheConfig = new CacheConfiguration<>("paramControlCache");
cacheConfig.setIndexedTypes(Key.class, Model.class;
cacheConfig.setReadThrough(false);
cacheConfig.setAtomicityMode(ATOMIC);
cacheConfig.setCacheMode(CacheMode.PARTITIONED);
cacheConfig factory = new CacheCacheFactory();
cacheConfig.setCacheStoreFactory(factory);
cacheConfig.setDataRegionName("CacheDataRegion");
cacheConfig.setOnheapCacheEnabled(true);
How does this happen? Is there something I am missing out ??
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
