If it is a Free table, you could. If it is in a DBC, you may have troubles.
If I remember correctly, there is a header connecting a table to a DBC.

You may need to ZAP the original and append from the Free table. However, if
you have an AutoInc integer field, you'll have problems.


HTH,
Tracy


-----Original Message-----
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Desmond
Lloyd
Sent: Monday, October 05, 2020 10:37 AM
To: profoxt...@leafe.com
Subject: Re: My memo field(s) Are Bloated......

Fascinating,  original size of the DBF 710448
original size of fpt: 1276848

selecting * from the tabl3
DBF = 710448
FPT =  923354

A drop in the size of the fpt of 353492.. Could i rename the "selected" FPT
and use it.   I treid a pack memo and there no change in thesiz of the FPT?

Regards,
Desmond

/

On Mon, 5 Oct 2020 at 09:06, Tracy Pearson <tr...@powerchurch.com> wrote:

> When you select * to a temp table. What is the size of the files?
> You'll know quickly if you have bloat.
>
> HTH,
> Tracy
>
> -----Original Message-----
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Desmond
> Lloyd
> Sent: Monday, October 05, 2020 9:49 AM
> To: profoxt...@leafe.com
> Subject: My memo field(s) Are Bloated......
>
> Good Morning!
>
> Have a very wide dbf with about 8 memo fields .   Started
> acteing strange like if I tried to re-index or pack memo it would seem to
> go so far and then freeze!
>
> Found a utility that seemed to repair the file.  The only issue is that
the
> DBF is 710mb and the associated memo file is 1.2gb!  Yikes.  Have ran a
> pack memo (with no  issues) and there is no change in the size of the memo
> file,  which I am assuming is boated.
>
> 1.)  Is the memo file really bloated.
> 2.)   Going to look at the individual memo fields and see if any one of
the
> records has an unusually large memo field.
> 3.)  Open to any other suggestion that you wise people could recommend....
>
> TIA/Regards,
> Desmond
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000a01d69b27$e824e450$b86eacf0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to