ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Mashenkov <andrey.mashen...@gmail.com>
Subject Re: How could imporeve UNION ALL performance
Date Sat, 10 Nov 2018 08:38:19 GMT
Hi,
 Can you share a query plan?
Do you have any indices on last and lastprice columns? Have you tried to
run queries separately without Union?


чт, 8 нояб. 2018 г., 23:47 wengyao04 wengyao04@gmail.com:

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

Mime
View raw message