>>>Hi
>>>
>>>In the last few days one of my larger tables FPT file has bloated alarmingly , twice going from 75,000 to over 2 GB in a couple of hours - I can deal with it at the time but how can I quickly stop it happening?
>>
>>Turn off your computer < s >
>>
>>Seriously, how about giving us some clues or code samples about what you're doing so we can offer reasonable ideas?
>
>Al
>
>I have discovered a couple of records on the file with memo fields which look blank but are over 100000 bytes - I have cleared them - hopefully that will stabilise it - thanks for your response
It can be useful to periodically scan memos and delete CHR( 0 )s, extended ASCII etc. thay may creep in as a result of crashes etc.
If you're not doing so already you could experiment with SET BLOCKSIZE TO 0 to reduce memo size.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up