Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Store Picture in General Field.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00428754
Message ID:
00429300
Vues:
21
>>I'm fully agree with you, storing the pictures in the table is a pain. The table will grow and grow, and search times will be going down. I always store only the path.
>
>Pablo, I disagree with you. I use 2 separate tables to store binary data. First table (documents) is main and used for search. Second table is binary data only related with documents table by ID. And space such data storing takes is not more than space that stored files takes on disk - no difference.

Well it's good to have different oppinions. But here's mine:

- You are right the data are in separate files DBF and FPT, and ok there is no extra low speed for seeking, that was a miss I did.
- I have observed that storing the pictures in the FPT you have extra bytes. I can't remember is this was for JPEG or bitmap, but I got more or less a 10% percent more.
- I wanna keep away from FPT all the data I don't really need there, and if this gaves me a table with no FPT. hurra! You should know of many FPT going corrupted.

Best,
Pablo Roca
Clavo Congelados, S.A. (La Coruna - Spain)
Sysop of PortalFox

Join MasFoxPro campaign
http://www.masfoxpro.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform