Skip to Content
Nov 15, 2022 at 03:39 AM

Docstore Collection table join is making the query execution extremely slow



We have 2 Docstore/Collection tables. We need to join them and get appropriate data. We are facing following performance issues :

1. We need to create respective views as direct joining of these Docstores/collections is not allowed.

2. With large volume of data, it is taking huge time to execute the queries on joining these views.

Can someone please help us to solve this non-performant views' query execution issue ?