Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Extra memo
Message
De
28/02/2008 13:42:19
 
 
À
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:
01297497
Vues:
14
So far, always just a little bit of missing information...

4 million rows, but what is the row size? Does this include DELETED() rows?
- If you have deleted rows, are you in a position to remove them permanently?

What is your motivation for saving the space?... Are you having response time issues or space issues or what? If your FPT is indeed .6GB then why not just leave things as they are?




>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.
>
>
>>>I tried now pack memo (on backup).
>>>My file become fatter in 2% more.
>>>:)
>>
>>That doesn't make any sense, unless you changed the block size too.
>>
>>How many records? What percentage of records are less than 33 bytes? You may be better of changing your block size to 33 (minumum) instead of 67.
>>
>>How much space are you trying to save?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform