File size limits (OpenInsight 32-bit Specific)
At 26 JUL 2005 04:47:29PM matt bavis wrote:
We are adding a new feature to our product that has the potential to adding records very quickly to the database and will cause the files to grow much quicker than any files we currently maintain in our product.
I wanted to see if anyone can give me any insight into the following:1) Is there a limit on the number of records that can be created in a single table?
2) Is there a maximum size the LK and OV files can take up on disk (or is this only limited by the O/S)?
Thanks,
Matt
At 26 JUL 2005 06:49PM support@sprezzatura.com wrote:
1) I'm fairly sure Rev Us have trialled with 4,000,000,000,000 rows
2) Pre UD 4GB per LK/OV. UD 4GB pre frame.
support@sprezzatura.com
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
At 28 JUL 2005 04:58PM R Johler wrote:
]]
What does that "UD 4GB pre frame." mean?
We are thinking about the UD (but LOTS of thought because we lose all our IPX tracking tools)due to seemly constant battle with big files.
So one frame can hold up to 4GB? At some point it seems that access time would grow very large while the UD searches in 4GB of data for our one 500 byte record.
What is the practical file size limit then? So that access time doesn't grow very large say we keep frames at 4K or so. Assuming I'm not all wet on this. large splash
At 28 JUL 2005 05:02PM support@sprezzatura.com wrote:
Sorry 4GB per frame max. Don't think you'd bother with frame sizes this large until you were on a fibre optic network but nice to have the flexibility there. Like how Rev C allowed a 64K row when the maximum storage was a 320K floppy :).
support@sprezzatura.com
The Sprezzatura Group Web Site
World Leaders in all things RevSoft