>Back up the files before proceeding - then you can try:
>
>- PACK or PACK MEMO
>- Create a new table with the same structure, and either APPEND FROM the old one, or programmatically write the rows one at a time from the old to the new
>- Try a SELECT * FROM OldTable INTO NewTable
The system is live. The client is not willing to take the system down unless they can't work at all.
>and see if the file sizes are more reasonable.
>
>Does the .FPT size look reasonable? 1,906KB/300 rows is about 6.35KB/row - is that a reasonable average?
It is definitely not reasonable.
>SET BLOCKSIZE TO 0 may be useful as well.
Could you elaborate why this may be useful?
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature