Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Small adjustment needed on recycle approach
Message
De
07/05/2003 10:33:18
 
 
À
07/05/2003 02:58:44
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00785663
Message ID:
00785810
Vues:
19
>I think you're missing nothing. If you could use exclusive then pack/pack memo.
>AFAIK how memo works you don't have a way of saying 'recyle' memo block (header keeps 'next free block' and for performance reason data is not checked if there are unused block numbers and if it could fit into one of them).
>Hope someone has a trick.

I think this issue should be addressed to Microsoft. It is kind of irritating. I did a test locally by create a small table with two fields. One of them is a memo field. I put one paragraph in each of the record. I have two records. That gave me a file size of 2k. Then, I blank the first one. No change in the file size. Then, I added 10k of data in the blank record. It moves the file size to 12k. Then, I blank it again. No change in the file size. I change the memo value to "test". No change in the file size. So, right now, I have only one character in each record but the file size is over 15k. This creates overload of disk space for nothing. For example, I have a large process which is constantly cleanup things. Instead of just having my regular 15 mb file size, it keeps increasing by 20 mb per day and I don't have much more data every day.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform