Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Thomas Holt
  Where is Thomas Holt?
 Gloucester
 United Kingdom
 Thomas Holt
 To: Philippe Sevin
  Where is Philippe Sevin?
 Winston Salem
 North Carolina - United States
 Philippe Sevin
 Tags
Subject: RE: General fields and bloated FPT
Thread ID: 229 Message ID: 256 # Views: 2 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Monday, May 21, 2001 4:57:29 AM         
   


> Pack memo helps if the General field had been edited. But the problem remains that a linked Jpg file of 100kb adds 4 MB to the FPT file. It makes it impractical to use a general field to store picture in a table (1GB every 250 photos).
>
> P.S. Your web site looks great!
Hello


Ive always found a problem with large ftp file when using memo or general fields, the only thing that will reduce it a bit is to try out a few SET BLOCKSIZE values look in help for more info, you need to open the table then issue SET BLOCKSIZE TO say...64 then copy the table to a new table, the new table has the new blocksize.

hth

Tom

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