Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detect CDX Bloat
Message
From
08/02/2004 04:17:32
 
 
To
08/02/2004 03:47:18
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00875209
Message ID:
00875244
Views:
29
With PACK ( it copy the DBF,FPT and recreate CDX) the solution is simple, but i want use this shema:
#DEFINE BLOATLIMIT  0.5
IF CDXBloatRatio('MyTable')>BLOATLIMIT   && if bloat is little a PACK is useless
   TRY
     SELECT 0
     USE MyTable EXCLUSIVE
     PACK
   CATCH
   ENDTRY
ENDIF
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform