Hi Moti,
Could you please attach execution plans for both LOCAL and REPLICATED cases?
On Wed, Sep 5, 2018 at 6:13 PM ilya.kasnacheev
wrote:
> Hello!
>
> Unfortunately I'm not aware why you see such a big difference in this case.
> It should be comparable. Maybe SQL people will chime in?
>
>
Hello!
Unfortunately I'm not aware why you see such a big difference in this case.
It should be comparable. Maybe SQL people will chime in?
Regards,
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hey :)
Actually I use the java api in order to query the ignite DB and I managed to
reduce the query time by using setLocal(true).
But my real question is that according to documentation it should work the
same whether I use local or replicated, So why with replicated it takes so
much longer?
Hello!
Can you try setting replicatedOnly(true) hint on SqlFieldsQuery, or
;replicatedOnly=true parameter for Ignite Thin JDBC Driver? This will
prevent query to be distributed between nodes.
Regards,
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hi,
I have this query (used Explain on original query):
SELECT
COUNT(DISTINCT _1__Z3.IP) AS __X0
FROM (
SELECT
ENDPOINT__Z0___KEY AS IP,
ENDPOINT__Z0__ELEMENTID AS TARGET,
CASEWHEN((ENDPOINT__Z0__STATUS IS NOT 'RULES_PENDING_ADD'),
ENDPOINT__Z0__STATUS,