Running a report without indexes

Kenneth Brody kenbrody at spamcop.net
Thu Mar 21 08:07:34 PDT 2013


On 3/19/2013 3:03 PM, Ian Wood wrote:
> Ken,
>
> "If you aren't running via an index, and you are not updating any records,
> and you are not doing any indexed lookups, then filePro shouldn't be
> accessing the indexes beyond reading the automatic index headers when the
> file is opened."
>
> I get that point that you're making, but the point is filePro IS obviously
> trying to access those indexes. There are precisely ZERO lookups in the
> processing table. The command line does NOT contain -i*

I understand what you are saying.  But, you also keep asking if there's a 
way to have filePro ignore indexes.  The answer is no.  Either it needs the 
indexes, because it's using them, or it's already not using them.  (If you 
get my meaning.)

There are very few places where an "invalid index" can be generated, and the 
only one that should ever be even possible in the scenario you describe 
(read-only mode, no lookups) would be if filePro couldn't read the index 
header when the file is first opened, or the "magic number" wasn't valid. 
And, short of transient network errors (assuming the files are stored on a 
network share), neither of those make sense for such an intermittent problem.

-- 
Kenneth Brody


More information about the Filepro-list mailing list