Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to speed up
Message
From
17/11/2003 18:48:12
 
 
To
17/11/2003 18:14:14
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00850812
Message ID:
00850820
Views:
14
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*
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform