The JADE 2022 release meets tomorrow’s business demands.
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
