Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BIG!!!! Pictures in General fields and VERY slow
Message
From
13/12/2003 06:34:26
 
General information
Forum:
Visual FoxPro
Category:
Pictures and Image processing
Miscellaneous
Thread ID:
00858269
Message ID:
00858885
Views:
10
Hi Jonathan

Your comment that it is not more logical to keep each picture in separate files than to include them in a memo file is your own opinion, and of course you have every right to have your own opinion. However, I must argue that I can see absolutely no advantage in doing so, but it mat depend on the number of pictures, and whether they are static or may be changed in some way. I will argue that in most cases seperate pictures is a much better idea, and far more extensible. Also keep in mind that if you want to change some pictures, with your approach you will run into memo file bloat.

In all the apps I have made over the last 20 years, I have never had a case where your method would have given me any advantage.

>I'm a month late to this thread but for storing picture I've have good luck using a binary memo field instead of either a general field or storing the name of a separate image file. Doing so reduces file bloat (caused by the general field containing not only the image but also a preview picture), and in my mind it's no more logical to keep each picture in an entirely separate file than it would be for any other column of data. How-to details were published in the Advisor Answer's column of July '99's Foxpro Advisor - basically you use APPEND MEMO [fieldname] from [filename] OVERWRITE to get the picture into the binary memo field and COPY Memo [tablename.fieldname] TO [filename] to get it back out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform