Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to speed up
Message
De
17/11/2003 18:48:12
 
 
À
17/11/2003 18:14:14
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00850812
Message ID:
00850820
Vues:
16
Shouldn't existing indexes be preserved exactly when a table is zapped? My first guess was a change in collation since mismatches there tend to have dramatic effects (docs say Rushmore doesn't use indexes if their coll differs from the current one) but zapping doesn't change the collation AFAIK. Blocksize perhaps? ISTR that a table takes on the current setting for blocksize if you pack it.

Also, NTFS reacts very badly to fragmentation. Had a big performance problem today with some tables that were copied en block but ended up in the cracks between a million fragments created by TurboDB. Raw file reads from that drive were slower than reads from a 10 MBit network, and the defragger wailed that there was no free space that it could use (0%) even though it reported 53% free space on that drive. Defragged by reformatting and afterwards performance was back to normal levels. *g*
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform