Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Extra memo
Message
De
28/02/2008 13:24:47
 
 
À
28/02/2008 13:13:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01297347
Message ID:
01297484
Vues:
7
>I have 4 milion rows in this table (I counted the dbf but the memo with content in all rows).
>60% of the rows - 11 length.
>20% 12-32
>19.95% 33-58
>0.05% - 67
>
>I want to svae space.
>
>if its les 100 mb
>	its not worth
>else&&(more)
>	its importent
>endif
>
>I need help with the set blocksize syntax.

You must create a brand new table in order to use a new blocksize. The blocksize in effect when a new table is created, stays fixed for this new table.
Set blocksize to 50
Use oldtable
copy to newtable 
use
copy file newtable.* to oldtable.*
use oldtable exclusive
Index on.. && To recreate the index tags.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform