Improving FP performance?

[Steve Bergman]

Hi,

Thanks, Walter, for the reply.  The RAID array wouldn't help a whit in
this case.  With 2GB of memory, the data all fits in the cache.  You're
right about my being more familiar with the internals of PostgreSQL.
But in this case I was thinking of Cobol and C/Isam files and the need
for a rebuild/export/import from time to time.  IIRC from years back,
Filepro marks records for deletion but does not immediately remove
them.  However, if the file is growing, it *can* reclaim that space for
new records. These files would be growing.

I know that an index is being used to do the initial selection of
records in the main file.  Is it possible in filepro to do a lookup that
does *not* use an index?  I don't think there is.  I think you have  to
specify an index as part of the lookup syntax.  But it *feels* like what
is happening is a bunch of unnecessary sequential scans.  We're only
dealing with ~2000 records, here, and not all *that* much processing.
It should be faster.

To answer your question. I believe that the processing only formats are
mostly doing record adds and updates.

Thanks,
Steve