ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergi Vladykin <sergi.vlady...@gmail.com>
Subject Re: Very slow cache query compared to H2
Date Fri, 03 Mar 2017 11:25:01 GMT
Looks pretty strange to me. Could you please share a simple reproducer with
us?

Sergi

2017-03-03 12:51 GMT+03:00 zaid <zaid.saeedi.khan@gmail.com>:

> 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.
>

Mime
View raw message