Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Magic Increasing Memo fields
Message
De
11/03/2002 11:12:07
 
 
À
11/03/2002 10:53:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00630993
Message ID:
00631012
Vues:
27
It's the way memos work. There are more details in an article on my web site. Basically, when a memo reaches its allocated space, the data for that record is moved to the end of the file. The previous space is not recovered.


>I am replacing string data in a memo field, without using the replace-additive command.
>
>The data gets replaced, but the table file size increases and increases until the table gets packed.
>
>Thie lage table sizes are causing performance issues, so any ideas would be appreciated.
>
>Thanks in advance
>
>Mike
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform