Hi we use ignite as our searching backend.
Our cache is in replicated mode and primary_sync. Our query is more like the
following. We find that that the query time is the sum of two sub-select
query. Since our two sub select query is independent, is there a way to run
them in parallel ? Thanks
SELECT market.id, market.name, market.lastPrice
FROM ((
SELECT marketR.id, marketR.name, marketR.lastPrice
FROM STOCK marketR
JOIN TABLE(exchange int = ?) ON i.exchange = marketR.exchange
WHERE marketR.subscription = 'TRUE' AND marketR.last > 50.
)
UNION ALL
(
SELECT marketD.id, marketD.name, marketD.lastPrice
FROM STOCK marketD
JOIN TABLE(exchange int = ?) ON i.exchange = marketD.exchange
WHERE marketD.subscription = 'FALSE' AND marketD.lastPrice > 50.
))
market ORDER BY market.lastPrice DESC LIMIT 5000
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
