ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Nestrogaev <a.nestrog...@flexsoft.com>
Subject Re: Sql query performance with partitioned caches
Date Wed, 27 Jan 2016 12:38:26 GMT

Do not take the examples as the real problem.
In real application sql can be more complex like this:

select a.*
  from account a
  join account_details b
    on (b.id = a.id)
 where b.type = 'TTT'
   and (select nvl(sum(amount),0) from account_sums s where s.id = a.id) > 0
   and a.id = 1

Do you recommend to replace all such queries with java code using native
cache's api?

Thus it appears that ignite sql inginte with partitioned caches can't scale
for OLTP queries (every query runs on every node), it only will good serves
for DWH workload?

View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Sql-query-performance-with-partitioned-caches-tp2700p2742.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

View raw message