Looks pretty strange to me. Could you please share a simple reproducer with us?
Sergi 2017-03-03 12:51 GMT+03:00 zaid <[email protected]>: > 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. >
