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	469	October 17, 2021
Question about read transactions and isolation Help transactions	4	228	May 9, 2022
Date/Time scheduler question? Help	2	208	May 9, 2022
Price and Performance comparison Help	2	305	May 10, 2021
Can't count collections with more than 600 000 documents Help	1	609	February 16, 2021