The Jade 2025 release focuses on modernising the developer experience and helping you build faster, smarter, and more scalable applications.
Some of our customers databases have files that are quite large ? in one case the file size exceeds 400 GB. This file has a single class instances (and its exclusive collections). This becomes a problem when the file requires compacting or backing up.
We have looked at a couple of options ? partitioning and sub-classing to help alleviate this issue. For several reasons neither of these options are suitable for this environment.
What would be ideal would be to have a feature that allows instances of a single class to be split over several files. For an example, SQL Server provides the concept of File Groups ? see https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-2017
Benefits of having a single logical file and multiple physical files would be for speeding up compaction and backups.
Chendra Segaran
