Index issue?

[Richard Williams]

On 3/26/2014 4:41 PM, Steven Waters wrote:
> Filepro 5.0.14
>
> Hello,
> Not sure what happened but on one of our files the request output became very slow
> on all reports. This has never happened before. The file has 180,000 records.
> Inquire update add works just fine and I rebuilt all of the indexes.
> Thanks in advance with any ideas,
> Steve
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140326/ef0b6ecc/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2014.0.4354 / Virus Database: 3722/7253 - Release Date: 03/26/14
>
>
Steve,

Slow it what way?

Are you running a report?
Is it slow trying to access a record in inquire update and add?

Try accessing the file without automatic processing.

linux example:

/appl/fp/dclerk filename -S1 -Y noprc -U

Richard