I have deeply nested object. I calculate bunch of stats based on that object. => multiple separate N1QL queries in Eventing ( around 100 queries). The performance is very slow ~15-30 sec to create the output document. I am looking into indexes to improve performance.
- Is it better to create separate index for each query vs creating 1 index that covers all attributes and nested items?
- What is the best way to inspect performance of Eventing function, time it runs?