Skip to main content

Hi all,

Are there any limits for Vision 5 files, in terms of absolute number of records or file size?

Our client has a huge database of 2.5 mil records, dat file is 860MB, idx file is 470MB.

Acuserver runs on a Windows based server.

Hi all,

Are there any limits for Vision 5 files, in terms of absolute number of records or file size?

Our client has a huge database of 2.5 mil records, dat file is 860MB, idx file is 470MB.

Acuserver runs on a Windows based server.

There is a limit on the height of the index trees in a Vision file.  The height limit is 30, which implies about 1 billion records assuming 2 keys per index node.  In practice you will likely have more keys per node than that so the number of records can be very large.  Vision does maintain a reference number for unique records in the case of duplicate key values.  This number is incremented with each write operation and has a maximum of 2^31-1 or 2.14 billion.  Both limits are well above your record count of 2.5 million records so you should be fine.

Vision 5 files support up to 64K 2GB data segments and the same number of index segments, so file size limits should not be an issue for you either.