Hello
I am currently using FaunaDB for a project that involves managing large datasets, and I’m running into performance issues with queries. Despite using indexing, limiting the query scope, and applying the usual optimization techniques, response times remain slower than anticipated. The queries run fine with smaller datasets, but as the number of records grows, the performance starts to degrade.
I’ve been trying to understand the internal workings of Fauna’s query processing, and I suspect the issue might be related to how Fauna handles large collections in certain contexts. I’ve tried experimenting with different query patterns, but I haven’t been able to get significant improvements in performance.
I’d appreciate any advice from the community on what additional steps I can take to optimize query performance for large datasets. Checked Performance on large collections and indexes Selenium guide for reference but still need advice.
Are there specific FaunaDB features or configurations that can help speed up queries in this kind of scenario? Any best practices would be helpful!
Thank you!