Re: Poor cross cache join SQL performance (v2.0.0)

2017-07-12 Thread afedotov
Hi, As well as for regular DB, each group index relates only to one entity/table, so there is no such thing like cross cache group index. Kind regards, Alex. On Wed, Jul 12, 2017 at 3:22 PM, iostream [via Apache Ignite Users] < ml+s70518n14719...@n6.nabble.com> wrote: > Hi, > > Apologies for th

Re: Poor cross cache join SQL performance (v2.0.0)

2017-07-12 Thread iostream
Hi, Apologies for the delayed response. Implementing appropriate group indexes solved the problem for me. One question - can I create a group index across caches? Or group index can be created only within one cache? Thanks! :) -- View this message in context: http://apache-ignite-users.7051

Re: Poor cross cache join SQL performance (v2.0.0)

2017-07-07 Thread Alexander Fedotov
amp;id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -

Re: Poor cross cache join SQL performance (v2.0.0)

2017-07-06 Thread afedotov
Could you please share the reproducer? Kind regards, Alex 6 июля 2017 г. 11:18 AM пользователь "iostream [via Apache Ignite Users]" < ml+s70518n14382...@n6.nabble.com> написал: > Hi Alex, > > Yes Value2.class was already added to indextypes. > > I am only reading the value which is why copyOnRea

Re: Poor cross cache join SQL performance (v2.0.0)

2017-07-06 Thread iostream
Hi Alex, Yes Value2.class was already added to indextypes. I am only reading the value which is why copyOnRead is set to "false". -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Poor-cross-cache-join-SQL-performance-v2-0-0-tp14373p14382.html Sent from the Apach

Re: Poor cross cache join SQL performance (v2.0.0)

2017-07-06 Thread afedotov
Hi, Add Value2 to the list of the indexed classes (setIndexedTypes). What is the reason for setting copyOnRead(false)? If the problem still stands after the fix, please check GC or take a JFR. Kind regards, Alex 6 июля 2017 г. 7:29 AM пользователь "iostream [via Apache Ignite Users]" < ml+s7051

Poor cross cache join SQL performance (v2.0.0)

2017-07-05 Thread iostream
Hi, I have 2 caches, each with POJO values that look like - public class Value1 { @QuerySqlField(index = true) private Long a; @QuerySqlField(index = true) private String b; } public class Value2 { @QuerySqlField(index = true) private