Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FPT file suddenly goes over 2GB
Message
From
26/04/2007 05:01:16
 
 
To
26/04/2007 04:33:30
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01219223
Message ID:
01220026
Views:
28
>>Try open the table exclusive
>>and apply PACK
>>maybe there are a lot of deleted records
>
>No, try it. Every replace command with memo fields increas memo file size. I don't use memo fields because of that. But PACK MEMO command packing memo file. VFP doesn't replace old memo part with replace command. It deletes old memo and appends new memo at the end of file.

You are wrong. VFP will put the memo back into the same place if it still fits. A lot depends on the SET BLOCKSIZE that was in effect when the table was created. If you know that your memo fields are going to go through significant additions over time you should use a bigger blocksize, this will reduce the number of times that a memo actually needs to be moved to a new space allocation inside the FPT. Read more here http://fox.wikis.com/wc.dll?Wiki~MemoBloat.

I use memo fields a lot, and I have no problem with this.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform