I have created an index on partyId of Account cache, after that query is responding in milli seconds.
However, my basic affinity and collation does not seems to be working. I have created records with Ids from P101000000 to P101010000. If you see below, some of the records are not returned, does that means they are not collacated. 0: jdbc:ignite:thin://127.0.0.1> select P.PARTY_ID, A.PARTY_ID, P.ACCOUNT_ID_LIST from "Customer".Customer P, "Account".Account A where P.PARTY_ID='P101000016' and P.PARTY_ID= A.PARTY_ID; +--------------------------------+--------------------------------+--------------------------------+ | PARTY_ID | PARTY_ID | ACCOUNT_ID_LIST | +--------------------------------+--------------------------------+--------------------------------+ +--------------------------------+--------------------------------+--------------------------------+ No rows selected (0.01 seconds) 0: jdbc:ignite:thin://127.0.0.1> select P.PARTY_ID, A.PARTY_ID, P.ACCOUNT_ID_LIST from "Customer".Customer P, "Account".Account A where P.PARTY_ID='P101000023' and P.PARTY_ID= A.PARTY_ID; +--------------------------------+--------------------------------+--------------------------------+ | PARTY_ID | PARTY_ID | ACCOUNT_ID_LIST | +--------------------------------+--------------------------------+--------------------------------+ | P101000023 | P101000023 | A101000023 | +--------------------------------+--------------------------------+--------------------------------+ 1 row selected (0.011 seconds) 0: jdbc:ignite:thin://127.0.0.1> select P.PARTY_ID, A.PARTY_ID, P.ACCOUNT_ID_LIST from "Customer".Customer P, "Account".Account A where P.PARTY_ID='P101000024' and P.PARTY_ID= A.PARTY_ID; +--------------------------------+--------------------------------+--------------------------------+ | PARTY_ID | PARTY_ID | ACCOUNT_ID_LIST | +--------------------------------+--------------------------------+--------------------------------+ +--------------------------------+--------------------------------+--------------------------------+ No rows selected (0.022 seconds) What could be the reason Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
