Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ryss Unger
  Where is Ryss Unger?
 Cape Town
 South Africa
 Ryss Unger
 To: Ryss Unger
  Where is Ryss Unger?
 Cape Town
 South Africa
 Ryss Unger
 Tags
Subject: RE: Another reason to use normal memo for archive
Thread ID: 229 Message ID: 250 # Views: 3 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Sunday, May 20, 2001 5:35:37 PM         
   


> > Hi Philippe,
> >
> > I tried some things my self and found the following:
> >
> > A small jpg file (24.576) created a fpt file of 1.282.048 bytes when I append general from jpgfile. The fpt file was only 856.064 bytes when i append general from jpgfile linked. Just like you said. It makes no difference if i register a different application with jpg file type.
> >
> > I then converted the jpg file to a 24bit bmp (425.984). When i append general from bmpfile, the fpt file is 425.984 bytes. When i append general from bmpfile linked, the fpt file is 851.968. Now that is weird!
> >
> > My advise:
> > 1) store the path to the file instead of the file in your table. There are lots of controls available to display jpg files on a form and starting with VFP, jpg is natively supported.
> >
> > if that is not possible for you:
> > 2) convert the jpg files to bmp and use append general from bmpfile and do not use the linked parameter.
> >
> > My guess is that VFP stores multiple copies (probably with different color and size dimensions) of the jpg file, or perhaps VFP converts the jpg to a bmp like format.
> >
> > ----------------
> > Hth,
> >
> > Eric den Doop
> > www.foxite.com
> Hi,
> Very intersting observations.
>
> When concidering the size comparison between JPG and BMP, the later is much bigger.
> If jpeg stored in a normal memo, nad copied to HD as required .. all size issues are resolved.
>
> Futher testing and notes in FAQ refer or will refer
>
> R
> Ryss

Hi,
Did some tests and got simailar results. FPT file 7mb Adding a JPG file of 94K.
Have both memo and general fileds in this file.

First append to memo filed increased file by 262208 . Had a panic attack. Packed the file and it dropped in size by lots.(500K)

Appended same file again and this time had an overhead of only a few bytes.
Append general with overhead of 3000 bytes. This was not linked but embedded.

Could be the state of the FPT file and how many overwrites have been done, which may require file to be packed not only on conserve space on existing content but also on new additions.

Looks like some more research is required.

HTH
R
Ryss

ENTIRE THREAD

General fields and bloated FPT Posted by Philippe Sevin @ 5/18/2001 1:09:48 PM
RE: General fields and bloated FPT Posted by Eric den Doop @ 5/18/2001 1:40:13 PM
RE: General fields and bloated FPT Posted by Philippe Sevin @ 5/18/2001 2:07:46 PM
RE: General fields and bloated FPT Posted by Paul Culbertson @ 5/18/2001 2:22:39 PM
RE: General fields and bloated FPT Posted by Philippe Sevin @ 5/18/2001 3:15:35 PM
RE: General fields and bloated FPT Posted by Eric den Doop @ 5/18/2001 7:00:28 PM
RE: General fields and bloated FPT Posted by Philippe Sevin @ 5/18/2001 8:13:09 PM
RE: General fields and bloated FPT Posted by Eric den Doop @ 5/19/2001 6:53:33 PM
RE: Another reason to use normal memo for archive Posted by Ryss Unger @ 5/20/2001 11:57:27 AM
RE: Another reason to use normal memo for archive Posted by Ryss Unger @ 5/20/2001 5:35:37 PM
RE: Another reason to use normal memo for archive Posted by Dale Dedoroy @ 5/20/2001 10:53:10 PM
RE: The real story ... Posted by Eric den Doop @ 5/21/2001 9:39:20 AM
RE: The real story ...Network Traffic Posted by Ryss Unger @ 5/21/2001 12:30:52 PM
RE: General fields and bloated FPT Posted by Thomas Holt @ 5/21/2001 4:57:29 AM