Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems With General Field
Message
From
30/10/1996 13:27:02
 
 
To
30/10/1996 11:53:25
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00011120
Message ID:
00011150
Views:
29
>I disagree with this opinion. Surely if we have few images we can keep them as separate files. But what's happened when we have thousand records? There is a bottom line: data stored in database! To avoid fpt bloating problem we have to create right data design:
>1. Master file contains just links (foreign keys) to Image table.
>2. Image table contain just 2 fields: ID and GenImage.
> So deletion/creation records in Master file (frequent case) will not affect size of image table. Surely Image Table maintenance shoul include packing.

IMHO this is ok only if you don't edit the pictures frequently

Arnon
Previous
Reply
Map
View

Click here to load this message in the networking platform