I have 3 cache store and each has its own table. When I tried to do simple join, query is taking longer in DBeaver. Server topology is ver=4, servers=1, clients=1, CPUs=4, offheap=3.2GB, heap=6.0GB
Cache 1. GroupCache"."[GROUP]" has 100k records Cache 2. "GroupMemberCache".GROUP_MEMBER has 200k records Cache 3. "CustomerCache".CUSTOMER has 200k records Query is as below SELECT CUST.Name FROM "GroupCache"."[GROUP]" GRP INNER JOIN "GroupMemberCache".GROUP_MEMBER GM ON GRP.Group_Customer_ID = 44 INNER JOIN "CustomerCache".CUSTOMER CUST ON GM.Customer_ID = CUST.Customer_ID AND GM.Record_Is_Valid = 'Y' AND GRP.Record_Is_Valid = 'Y' AND GRP.Group_Customer_ID = GM.Group_Customer_ID AND GM.Record_Is_Valid = 'Y' Query is executing longer than 2000 seconds. Any suggestion on this? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
