Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Approaching 2 gig
Message
From
29/12/2006 11:08:57
 
 
To
15/12/2006 04:14:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01068294
Message ID:
01180886
Views:
22
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform