1) Can you post the query plan? 2) what is your CacheConfiguration.queryParallelism setting? 3) What is your affinity_key? 4) What are your primary keys?
On Thu, Sep 27, 2018 at 1:40 PM Skollur <skol...@idbny.com> wrote: > 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/ >