2 replies to this topic

[Rob Donovan]

Hi,

Does anyone else have CISAM files that are near to or over the 2GB (theoretical) file size limit.

We have files up to 6GB at the moment, which is far too big and slow for performance. Splitting the file and Aliasing it in functions isn't really an option as the files are in too many functions and it would make our functions too slow.

I'm thinking of trying to change the kernel to alias the files automatically so that we don't have to make any code changes.

Does anyone else have this problem, or know of any problems with CISAM files over 2GB?

Rob

[James Lolley]

We do use C-ISAM for files that are larger than the current (384Mb) limit for Pro-Isam, but have not reached the 2Gb limit for C-ISAM yet!

[Richard Bassett]

I am aware of customers using C-ISAM files larger than 2Gb.
I think you may need a 'special' from Pro-IV and/or Informix to exceed 2Gb.
In my (limited) experience, C-ISAM performance degradation is commonly due to files not being reorganized after many records have been deleted - rather than simply size.