Stupid @rn question

Jean-Pierre A. Radley appl at jpr.com
Sat Sep 23 16:57:19 PDT 2006


John Esak propounded (on Sat, Sep 23, 2006 at 07:32:06PM -0400):
| 
| > On Fri, Sep 22, 2006 at 08:04:44PM -0400, Scott Walker wrote:
| > @rn is is an eight character field.
| >
| > What's happens when an fp file goes about 99999999 records.
| 
| Well, let's see. Assuming you consider 1 megabyte to be 1000 kilobytes and 1
| gigabyte to be 1000 megabytes... (not 1024 kilobytes and 1024 megabytes...
| which, who knows may be what many consider them to be...)  In any case,
| Using the former suggestion...
| 
| npi-p7# bc
| 1024*1000
| 1024000         1 megabyte
| .*1000
| 1024000000      1 gigabyte
| .*2
| 2048000000      2 gigabyte file size limit on system filePro previously
| desgined on
| 
| And considering there is a 20 byte header for every record  in a filePro
| database (plus a zero'th record which will ignore for the moment.) And, you
| must have at least 1 byte in every record wouldn't you think, just to make
| it a record of *something*. ;-)  That would be:
| 
| 99999999*21
| 2099999979
| 
| So, you would hit the file size limit *before* you hit filePro's limit. No
| foul, no error. :-)
| 
| However, I know we've had this discussion here a few times before and I
| believe that the upshot is/was that filePro has made some allowance for @rn
| on platforms that can store files bigger than 2Gb. Which, means you can have
| somewhere around a bazillion records I think.

The specs on the fP web page still claim that the limit is 1 billion
records.  Does filePro generate extended key files if it hits an OS's
filesize limit?

-- 
JP
	==> http://www.frappr.com/cusm <==


More information about the Filepro-list mailing list