Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Limitation to General Memo (ftp)
Message
From
16/05/2003 16:29:36
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
16/05/2003 16:21:19
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00789426
Message ID:
00789483
Views:
18
>Hilmar,
>
>What's your point #2 (20 times as much...)? I've not heard this before.

That's my personal estimate - the exact situation may make the factor vary.

Aadding a 50 KB JPG file to a general field made the memo field more than 1 MB bigger.

I believe that with compressed formats like JPG or GIF, the difference is especially dramatic, because - if I understand correctly - the general field saves two copies of a file: one, the original version, and the other, a standardized version, for display. This latter would be uncompressed, IOW, just as if you convert the JPG to a BMP.

Just try this test: Create a table with a general field, and add a single empty record. Import a single JPG image to the general field, and see how much the table size increases.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform