Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BLOBs Anyone?
Message
From
05/10/2001 07:52:27
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
04/10/2001 12:13:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00564183
Message ID:
00564680
Views:
14
>It does sound like a lot more space may be used up storing Blobs this way.
>I wonder if the effect is constant or if it is only noticed if you have a few Blobs to store in the FPT.

Try it! I tried it with a single General Field (=BLOB), and rashly extrapolated to 1000 files.

Just create a small table with a General Field, and use (I think) APPEND, followed by APPEND GENERAL, to fill the general fields with some sample JPGs.

>Maybe it is a one off penalty and does not get much worse if you add a lot of Blobs.

Actually, I compared the empty file, with the filesize after adding one JPG. But it may still be interesting to compare what happens when you add 10, or 100, JPGs.

You can probably add the same JPG 100 times, in a loop.

Hilmar.
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