Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Funadamental Design Flaws - You Wannem I Gottem
Message
De
14/06/1998 11:39:23
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
12/06/1998 19:22:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00106772
Message ID:
00108005
Vues:
49
>Again, this method is not used for monster tables. I inherited a situation here were there are hundreds of small tables to be maintained. Slowly these are being consolidated. In the meantime, I use the pack-on-exit method to perform table maintenance during times when the tables are not being used. It is merely a means of using available time efficiently -- and it is more effective than I though it would be. Sometime during the week almost all of the small tables get packed at least once.

>A table that needs to be packed is listed in the packlist. If it is packed when the form is exited, it is removed from the packlist. Then during regular scheduled table maintenence, it is one less table to be dealt with.

You seem to have drilled a hole in time - and given your scenario (many relatively small tables), it's probably the best approach (apart from bringing the system down periodically just for packing). I'm almost sory my tables have very few deleted records, so I have no use for this idea, but I do like it... Just one more question - long time ago I had done some testing on this issue (in FP1.02 or so), and I decided a table was a candidate for packing when it exceeded the 10% of deleted records. What's your approach - when exactly do you say that a table needs packing?

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform