Hi Igor, The result set has 907171 rows. I am running a 4 node cluster. The query hits three caches with rows 30024916,20196,4892601. The results are columns from SHOP_ITEM_BITMAP_CACHE.
Here is the config - <bean class="org.apache.ignite.configuration.CacheConfiguration"> <property name="name" value="SHOP_ITEM_BITMAP_CACHE" /> <property name="atomicityMode" value="ATOMIC"/> <property name="backups" value="0"/> <property name="memoryMode" value="ONHEAP_TIERED"/> <property name="offHeapMaxMemory" value="0"/> <property name="swapEnabled" value="false"/> <property name="cacheMode" value="PARTITIONED" /> <property name="affinity"> <bean class="org.apache.ignite.cache.affinity.rendezvous.RendezvousAffinityFunction"> <property name="partitions" value="128"/> </bean> </property> <property name="cacheStoreFactory"> <bean class="javax.cache.configuration.FactoryBuilder$SingletonFactory"> <constructor-arg> <bean class="com.nielsen.poc.aggregation.ignite.datagrid.store.ShopItemBitmapStore"> </bean> </constructor-arg> </bean> </property> <property name="readThrough" value="true" /> <property name="queryEntities"> <list> <bean class="org.apache.ignite.cache.QueryEntity"> <property name="keyType" value="java.lang.Long" /> <property name="valueType" value="com.nielsen.poc.aggregation.ignite.datagrid.model.ShopItemBitmap" /> <property name="fields"> <map> <entry key="id" value="java.lang.Long" /> <entry key="sid_per_id" value="java.lang.Long" /> <entry key="sid_mah_id" value="java.lang.Long" /> <entry key="sid_itm_id" value="java.lang.Long" /> <entry key="sid_prm_id" value="java.lang.Long" /> <entry key="sid_cha_code" value="java.lang.String" /> <entry key="sid_service" value="java.lang.String" /> <entry key="sid_itm_dist" value="java.lang.String" /> </map> </property> <property name="indexes"> <list> <bean class="org.apache.ignite.cache.QueryIndex"> <constructor-arg value="sid_mah_id" /> </bean> <bean class="org.apache.ignite.cache.QueryIndex"> <constructor-arg value="sid_itm_id" /> </bean> </list> </property> </bean> </list> </property> </bean> <bean class="org.apache.ignite.configuration.CacheConfiguration"> <property name="name" value="MARKET_POD_ACV_CACHE" /> <property name="atomicityMode" value="ATOMIC"/> <property name="backups" value="0"/> <property name="memoryMode" value="ONHEAP_TIERED"/> <property name="offHeapMaxMemory" value="0"/> <property name="swapEnabled" value="false"/> <property name="cacheMode" value="REPLICATED" /> <property name="cacheStoreFactory"> <bean class="javax.cache.configuration.FactoryBuilder$SingletonFactory"> <constructor-arg> <bean class="com.nielsen.poc.aggregation.ignite.datagrid.store.MarketPodAcvStore"> </bean> </constructor-arg> </bean> </property> <property name="readThrough" value="true" /> <property name="queryEntities"> <list> <bean class="org.apache.ignite.cache.QueryEntity"> <property name="keyType" value="java.lang.Long" /> <property name="valueType" value="com.nielsen.poc.aggregation.ignite.datagrid.model.MarketPodAcv" /> <property name="fields"> <map> <entry key="id" value="java.lang.Long" /> <entry key="mrkt_key" value="java.lang.Long" /> <entry key="prd_id" value="java.lang.Long" /> <entry key="chld_mrkt_key" value="java.lang.Long" /> </map> </property> <property name="indexes"> <list> <bean class="org.apache.ignite.cache.QueryIndex"> <constructor-arg index="0"> <list> <value>mrkt_key</value> <value>prd_id</value> <value>chld_mrkt_key</value> </list> </constructor-arg> <constructor-arg index="1" value="SORTED"/> </bean> <bean class="org.apache.ignite.cache.QueryIndex"> <constructor-arg value="chld_mrkt_key" /> </bean> </list> </property> </bean> </list> </property> </bean> <bean class="org.apache.ignite.configuration.CacheConfiguration"> <property name="name" value="PROD_HIER_CACHE" /> <property name="atomicityMode" value="ATOMIC"/> <property name="backups" value="0"/> <property name="memoryMode" value="ONHEAP_TIERED"/> <property name="offHeapMaxMemory" value="0"/> <property name="swapEnabled" value="false"/> <property name="cacheMode" value="REPLICATED" /> <property name="cacheStoreFactory"> <bean class="javax.cache.configuration.FactoryBuilder$SingletonFactory"> <constructor-arg> <bean class="com.nielsen.poc.aggregation.ignite.datagrid.store.ProdHierStore"> </bean> </constructor-arg> </bean> </property> <property name="readThrough" value="true" /> <property name="queryEntities"> <list> <bean class="org.apache.ignite.cache.QueryEntity"> <property name="keyType" value="java.lang.Long" /> <property name="valueType" value="com.nielsen.poc.aggregation.ignite.datagrid.model.ProdHier" /> <property name="fields"> <map> <entry key="id" value="java.lang.Long" /> <entry key="ghd_hie_id" value="java.lang.Long" /> <entry key="ghd_lev_0" value="java.lang.String" /> <entry key="ghd_lev_1" value="java.lang.String" /> <entry key="ghd_lev_2" value="java.lang.String" /> <entry key="ghd_lev_3" value="java.lang.String" /> <entry key="ghd_lev_4" value="java.lang.String" /> <entry key="ghd_lev_5" value="java.lang.String" /> <entry key="ghd_lev_6" value="java.lang.String" /> <entry key="ghd_lev_7" value="java.lang.String" /> <entry key="ghd_lev_8" value="java.lang.String" /> <entry key="ghd_lev_9" value="java.lang.String" /> <entry key="ghd_lev_2_desc" value="java.lang.String" /> </map> </property> <property name="indexes"> <list> <bean class="org.apache.ignite.cache.QueryIndex"> <constructor-arg index="0"> <list> <value>ghd_hie_id</value> <value>ghd_lev_2_desc</value> </list> </constructor-arg> <constructor-arg index="1" value="SORTED"/> </bean> <bean class="org.apache.ignite.cache.QueryIndex"> <constructor-arg value="ghd_lev_6" /> </bean> </list> </property> </bean> </list> </property> </bean> This query takes 10-14 secs for getAll. Can this be made to 1-2 secs? Thanks, Arthi -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Host-Arrays-in-C-API-tp3707p3715.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.