Improving FP performance?

[Steve Bergman]

Bob Stockler wrote:

>
>I don't understand what you mean by your above statement.  When a
>filePro record is deleted the space in the "key" (and "data" if
>used) file is not recovered, but is blanked out, and that space
>then becomes available for use by a newly created record.
>
>  
>
I guess what I mean is that my recollection of how FP works was only
kinda sorta right. ;-)

It sounds like filepro handles deleted records in a pretty efficient way
and that on a machine with enough memory that everything fits in the
page/buffer cache there is nothing to be gained from removing what
little deleted record space has not been reclaimed yet;  disk seeks are
not a factor in the cache. (And vmstat shows actual disk activity to be
minimal.  It's all processor time.  ~50% system, ~50% user, and almost
no waiting for I/O.)

I think I'll put my client directly in touch with this list.  There are
actually 30+ processing tables involved, some output processing and some
automatic processing.  He knows them.  I don't.  I'm sure Clay will be
able to ask more targeted questions.

Thanks for the enlightenment.

-Steve