Hi gareth,

VFP is great tool for manupulating data. However the tables of a database are limited to 2 Gig. You can always evaluate the table structure and determine if you could save memory:

For example Numeric (up to 9 or 10) positions can be held efficiently in an integer datatype which consume only 4 bytes.

Larger charachter fields which are used for remarks and may be filled in occasionally, might be better stored in a MEMO field. However you might have to change the procedures using this field to addres the new field type.

You can split the table in two vertically: This means you have one PK commonly in thos table, but for the rest of the columns you spread them over those two files. Of course you'll have to adapt your program.

Maybe you can give the STRUCTURE of those table. Maybe we can find a solution for this problem.

Walter,


>Can anyone tell me if you can compress a visual foxpro 5/6 datafile and still interact with it in real time. I have created 12 datafiles all around 2 gig in size but would like to make them into one file for searching. Is there maybe another operating system i could use instead of Windows?
>
>I have seen several products similar but they must be written in C. They allow very quick searches to take place and are accessing the same amount of records but the file size is less than 2 gig.
>
>I thought that Foxpro was the best language to use for minipulating data!
>
>Anyone got any ideas
>
>Regards
>
>Gareth.