Is there any restriction in number of fields or data volume?

Top  Previous  Next

Is there any restriction in number of fields / data volume?

 

The data is stored as a packed record structure inside the Audit file, with several unpacked fields used for indexing and searching. The structure of each record is taken from the current dictionary, it is not stored in the Audit file.

We made a contest to test the template under heavy stress, and we verified that the template can handle more than 900 files without problems. In our internal testings from version 1.7 and later is handling more than 900 files for recovering as well.

There is no limit in the number of fields that we are aware of (we tested with a file of 1700 fields).

The stored data volume is dependant on the database system you choose. If you pick TPS files, there is a 2 Gb size file limit (which still should be several million records, depending on your design). With other file systems (Like SQL or Btrieve 8.x+) the limit is given by your hardware storage.