Date/Time scheduler question?

[joillian]

Using a Fauna simple date/time key on a unique ID value (both FQL) writing sorted to disk - very roughly -around what’s the maximum write and read operations per second? The data structure would be a B Tree or something else?

[ptpaterson]

Hi @joillian and welcome to the forums!

We have an example of how to search for Documents by a date range, and it’s quite efficient in terms of reading and writing.

Basic cookbook

Fauna is highly scalable. In practice, your application will impose some limits on how much throughput you can get. The biggest limiters to write operations are

1. Contention: You can only write to a single Document so quickly. While writing/creating multiple documents in parallel is scalable to just about any degree, multiple transactions mutating the same Document have to be queued up and run serially.
2. Cost: In practice, you will likely be concerned with cost well before you hit limits of writes/second. Note that the more Indexes you have on a given source, the more expensive your writes will be in terms of performance (time) and cost (storage, write operations).

The bottom line is that you need to benchmark your own application, with your own data to truly determine how it works with Fauna. If you believe that you need more capacity, then we can work with you to make sure we have the infrastructure in place to handle your workload.

---

@joillian

The data structure would be a B Tree or something else?

Are you asking what the underlying storage structure is for Fauna? Or are you saying that you want to store your data in a B-Tree?

Here are some additional notes:

• Fauna uses a LSM-Tree based storage engine. Here are some resources if you are interested in diving deeper:
  • DynamoDB vs Fauna: Terminology and features
  • https://fauna-assets.s3.amazonaws.com/public/FaunaDB-Technical-Whitepaper.pdf (Note this one is a bit old, but still very detailed)
• Storing Documents with relationships like in a B-Tree is certainly possible! If you are writing a lot of data to Fauna and need to balance such a structure, then you might run into contention if the same node has to be updated frequently.