Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BLOBs Anyone?
Message
De
05/10/2001 07:52:27
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
04/10/2001 12:13:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00564183
Message ID:
00564680
Vues:
15
>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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform