Improving FP performance?

[Scott Nelson]

Steve Bergman wrote:

> 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
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>


Running filePro on a Striped RAID array like RAID 10 absolutely DOES run
faster.
A simple mirror will do little for performance.  I build such a machine
and have
plenty of experience and tests to show.  The typical RAID 10 box has 3
or 4 drives
in the striped array, and shows almost 3 or 4 times the data access I/O
than a single
drive.

You would have to see if your flavor of *nix has drivers or 3rd party
software
for RAID.  I use SCO OpenServer with the VDM from SCO, with No problems.

Scott Nelson
Logic Data Systems