Hi,
I am running a query using MySQL DB and Ignite SQL Grid. MySQL takes *56
millisecons* to execute the query whereas SQL grid takes *7220 millisecons*.
I have one client and one server node.
[11:52:48] Topology snapshot [ver=14, servers=1, clients=1, CPUs=8,
heap=11.0GB].
When I ran the same cache query in the embedded H2 console started from
Ignite node, it took *174 millisecons* for the first run and next run took
74 millisecons.
My caches configuration looks like as follows:
<bean class="org.apache.ignite.configuration.CacheConfiguration">
<property name="name" value="cache1" />
<property name="cacheMode" value="REPLICATED" />
<property name="indexedTypes">
<list>
<value>java.lang.String</value>
<value>com.poc.sqlgrid.cacheserver.vos.Cache1VO</value>
</list>
</property>
</bean>
My question is why SQL grid is taking too much time as compared to H2 to
execute the same query when I am using replicated mode? Also please note
that I am selecting only first 10 entries using the SQL LIMIT clause so
network overhead would be very minimal.
Do I need to add some configuration parameter to the cache config?
Thanks in advance.
Regards,
Zaid
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Very-slow-cache-query-compared-to-H2-tp11013.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
