ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Naveen <naveen.band...@gmail.com>
Subject Re: Affinity - Join query on the collocated data taking 90 seconds
Date Thu, 07 Dec 2017 19:10:35 GMT
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/

Mime
View raw message