Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extra memo
Message
From
28/02/2008 13:24:47
 
 
To
28/02/2008 13:13:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01297347
Message ID:
01297484
Views:
8
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform