Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File size of an FPT file
Message
From
12/04/2001 08:34:35
 
 
To
11/04/2001 18:49:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00494688
Message ID:
00494795
Views:
23
>Hi,
>
>I have built a table with one general field. The table has 710 records so far and each general field is linked (not embedded) to one-page MS Word document. The aggregate size of 710 Word documents is about 20MB, but the FPT file of my table is just about double that, namely 40MB. As I am planning to add a couple of hundred records every month, I am worried about the size of this FPT file. I packed the table, but the FPT file size remains the same. I understand that the general field holds only a reference to the linked object. Why is the FTP file so big?
>
>Have a nice day!
>
>cycho@nuri.net


You've discovered one of the problems of doing things this way. There is a KB article on my web site that discusses memo file bloat. In addition, the memo allocates disk space in blocks. IMO, you're better off keeping the word document as a separate file and then just storing the file name.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform