Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo file greater than 2g
Message
From
20/10/1999 10:08:31
 
 
To
20/10/1999 09:59:03
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00278798
Message ID:
00278808
Views:
14
>I know DBF files cannot exceed 2g, memo files can't either, can they? I have a memo files that contains images and it is getting close. Does anyone have any ideas on how to solve this besides splitting into multiple data bases?

You are correct - AFAIK, no file component of a VFP native table can, in and of itself exceed 2GB.

You might want to look at some sort of compression on the images stored in the memo field, compressing when stored and decompressing at extraction. Many image formats compress well using various LZH compression modules; you might want to examine using something like DynaZip to compress before storing and decompress after extracting if your app can better deal with the delays from compression/decompression than running out of space.

If you've not done periodic PACK MEMO commands, you may have lots of wasted space in the FPT file. Just make sure to back it up before issuing the PACK MEMO...
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform