We need to test scalability on AeonDb before we hit any limits on the production server. Some things to test:
- Record count: We have some production tables with 1 million records in a single segment (including deletion stubs). Is there a limit on record count? We should try creating a table with 10 million, 100 million, and 1 billion records.
- Update tests: We should try updating records in a table and see if we hit any limits (or bugs). For example, we should create a 1 million record table and then randomly update/delete/add records for as long as possible (10 million, 100 million updates, etc.).
- Record size test: We should try creating a database with very large record sizes. This is low priority because in practice we would handle this as file attachments.