Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Approaching 2 gig
Message
De
29/12/2006 11:08:57
 
 
À
15/12/2006 04:14:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01068294
Message ID:
01180886
Vues:
23
>Could you post the result of
>*-- Updated/not totally awake on first version...
>select ;
>      cast( IIF(Len(Alltrim(MemoFld))/50>30, 30, ;
>		Len(Alltrim(MemoFld))/50 )  as I) as LenMemo ;
>    , count(*) as CntMemo ;
>    from Table ;
>    group by 1
>
>as well as the current dbf/fpt sizes and reccount() to get better estimate of the numbers involved ?

Here is the result:
 0  22279
 1  42878
 2  55157
 3  62078
 4  66254
 5  67012
 6  65358
 7  62342
 8  59053
 9  54701
10  50604
11  46451
12  42527
13  38950
14  35041
15  32001
16  29263
17  26161
18  24143
19  21734
20  19734
21  17665
22  16405
23  14641
24  13306
25  12317
26  11079
27  10382
28   9138
29   8642
30 118375
Thread.cdx 48,317 KB
Thread.dbf 113,993 KB
Thread.fpt 893,656 KB
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform