Windows 2000 2 GB file limit

[Nancy Palmquist]

William James McEachran wrote:

> On Thu, Nov 04, 2004 at 02:01:40PM -0500, Jean-Pierre A. Radley wrote:
> 
>>William James McEachran propounded (on Thu, Nov 04, 2004 at 01:34:03PM -0500):
>>| On Thu, Nov 04, 2004 at 12:35:43PM -0500, Kenneth Brody wrote:
>>| > 
>>| > Use extended key files -- key, keyx1, keyx2, and keyx3.
>>| > 
>>| 
>>| The term is new to me. How do extended key files differ from qualifiers?
>>
>>RTFM:
> 
> 
> Now I don't have to :-) 
> 
> As a test, I used ddefine to create a new filePro file, answered "Y" to create
> qualifiers, and was able to create qualifiers 'x1', 'x2', and 'x3'
> resulting as expected in files name 'keyx1', 'keyx2' and 'keyx3'.
> 
> So it's possible for qualifiers and extended key files to step on each other.

I don't recommend this setup.

the x1-x3 are treated differently.

When you have KEY, and split the file by creating KEYX1, all new data is 
added to KEYX1.  The only change to KEY will be data that is modified. 
So in KEY you would have records 1-10,000 and in KEYX1 you would have 
records 10,001 and the END of your file.

When you make qualifiers, KEY, KEYQL you have in KEY records 1 to the 
end, and in KEYQL you have records 1- end.

When you add records to KEY they do not add to KEYQL.

It is possible, as I recall, to move the KEYX1 to the same filesystem as 
the KEY.  This has grown out of favor as the size of the hard Drives 
expanded.

Another solution might be to split the KEY into KEY and DATA.

By making the archive file with identical field numbers, but about half 
way thru put the rest of the fields in the DATA segment, you can still 
copy the records from the live to the archive as you do now, but the 
data would split into the two files.

This would double the space you have before the key or data hit the 2 
gig limit.

Nancy

All new

-- 
Nancy Palmquist
Virtual Software Systems
PHONE: (412) 835-9417			Web site:  http://www.vss3.com