I keep operational data in Fauna, and now have a need to log events for analytics. Is fauna suitable for this purpose in terms of performance (multi-field aggregations across many documents) and in terms of cost (many small write ops, no updates, aggregated reads)

@danbars , FaunaDB is an OLTP database and would not be a good choice for OLAP use cases. Improving aggregations is in our product road map.

Would you use Fauna for analytics?

databrecht February 16, 2021, 2:35pm 3

@danbars: The answer here might be interesting to you if you do use fauna and need analytics.

Topic		Replies	Views
Performance on large collections and indexes Help best-practices , indexes	5	530	October 17, 2021
Thinking about Fauna's suitability for a project Help best-practices , indexes	1	393	April 30, 2021
Question about read transactions and isolation Help transactions	4	253	May 9, 2022
Date/Time scheduler question? Help	2	231	May 9, 2022
Support multi-page queries Feature Requests fql , feature-request	2	59	September 9, 2024