Re: Difference between replicated and local cache mode regarding time execution of query

2018-08-29 Thread misraeli
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?

Difference between replicated and local cache mode regarding time execution of query

2018-08-28 Thread misraeli
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,