Is there any better way to improve performance of the TOPK-Projections?
We have some tables which are created in temporal model. For that I believe TOPK projections could be helpful. However refreshing and creating a fresh new topk projection takes lot of time especially table with 800K + records. Is there any best practices for creating and managing TOPK projections to improve the performance. Additionally, sometimes when using TOPK projections, the query hits the MaxOptMemMB although we set the size this to 400MB.