Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo fields... Is there some alternative for it?
Message
De
26/03/2003 19:23:50
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00770258
Message ID:
00770554
Vues:
13
Rodolfo,

Gerry's idea may be a good idea for your situation, but here's something to keep in mind. If the individual files would be small, you will end up wasting a lot of disk space relative to the amount of data you are storing. For example, if you have a cluster size of 8K on the disk, every file will use 8K of disk space, even if there is only 50 bytes in the file.

You can regularly pack the memo file, but memo files shouldn't waste space in situations where records are not deleted, and where the the contents of the memo field does not change after the memo field has been saved the first time.

>Hi!
>
>I use a couple of memo fields to save a audit data and I had been have some problems:
>
>1) The file grows up so fast...
>2) Sometimes, FPT file is corrupted.
>
>So, I'd like to know If I have other alternative to replace the memo fields...
>
>Any idea is appreciate! ;-)
>
>[]s!
Steve Gibson
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform