Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo field bloat
Message
De
23/02/2000 11:02:23
 
 
À
23/02/2000 10:01:14
Paul Robinshaw
Silkworm Technologies Limited
Macclesfield, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00335984
Message ID:
00336043
Vues:
19
>Hi All,
>
>I've come across something in the past few days that has worried me significantly.
>
>We have a table within our application that an associated fpt file. As I'm writing this the dbf stands at 3kb and the fpt at 600 MB, yes megabytes!!
>
>Anyway, on browsing the the table nothing seems odd. The data in the the fpt is right. This particular dbf had 80 or so records and each memo field has about 800 lines in it.
>
>This thing is really unstable and it's growing exponentially. It's like the opening scene few scenes in The 5th Element<s>
>
>Aside from bad code which I'm now checking, has anyone seen or heard of this before? Any help would be appreciated.
>
>Thanks
>
>Paul

There is a KB article on my web site that explains why memo bloat happens and what you can do about it.
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