Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FPT file suddenly goes over 2GB
Message
De
26/04/2007 11:11:54
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
 
 
À
26/04/2007 05:01:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01219223
Message ID:
01220171
Vues:
22
>>>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.

I didn't know set blocksize really... If I make it my max. memo size, my memo files won't bloated... Nice...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform