General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>Hi
>I got a project that done by other programer (unaviliable now).
>
>The database is very huge.
>
>I started to explore it and I seen the biggest file size is .fpt - memo.
>I went inside and I found that the maximum len is 67 (almost 80% len is 11), in addition, this is not sorce for edit box, it's only log field that base on other table list with few options and the maximum lenght could be 67.
>
>I prefere not to change the field type and my question is if there is a way to short the size (I remmenber something about SET BLOCKSIZE but I never used with this).
>
>In addition, I look for other tips/tools to help me shorting the database (it's more than 3GB after 4 years use).
According to the numbers you cited I guesstimate about 60 * 10**7 records, a fpt nearly 2 gig. If the dbf size is still below 1 gig, you could select sql [all dbf_flds,] Padr(left(MemoName, 10), 10) as Leftmemo, cast (subst(MemoName, 11) as M) as MemoName into a new table.
Should snip out slightly less than reccount()*10 bytes from FPT. Read in as Alltrim(Leftmemo) + MemoName and you are set.
HTH
thomas
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only