Running a report without indexes

[Ian Wood]

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*


Here is the command line:

\fp\dreport gr_ap -fp file_dump -u -a -v file_dump_s -y none -r "3CON" -h
"gr_ap"

Here is the processing table in it's entirety:

::declare local make_hd(1,allup,g):
::declare local field_ctr(5,.0,g):
::declare local head_ctr(5,.0,g):
::declare local detl_ctr(5,.0,g):
::declare local exp_filename(75,*,g):
::declare local bksl(1,allup,g):
::declare local delim(1,allup,g):
::declare local export_header_rec:
::declare local export_detail_rec:
::dim tot_fields[1000]:
::dim tot_names[1000]:
::bksl=chr("92"):
::delim=chr("124"):
:exp_filename eq "":gosub makefil:
::gosub xportem:
::end:
makefil:' ***makefil***::
::exp_filename="G
"{bksl{"EXPORT"{bksl{"RECON_FILES"{bksl{@fi{".txt":
::return:
xportem:' ***xportem***::
::export ascii out = (exp_filename) r=\n:
:make_hd ne "Y":gosub writehd:
::gosub writdet:
::return:
writehd:' ***writehd***::
::field_ctr="1":
head_lp:field_ctr gt numfield(-):make_hd="Y"; goto mkhdrec:
::tot_names[field_ctr]=fieldname(-,field_ctr):
::field_ctr=field_ctr+"1"; goto head_lp:
mkhdrec:' ***mkhdrec***::
::head_ctr="1":
hdreclp:head_ctr eq "1":export_header_rec=tot_names[head_ctr];
head_ctr=head_ctr+"1"; goto hdreclp:
:head_ctr le
numfield(-):export_header_rec=export_header_rec{delim{tot_names[head_ctr];
head_ctr=head_ctr+"1"; goto hdreclp:
::out(1)=export_header_rec; write out; return:
writdet:' ***writdet***::
okdtrec::field_ctr="1":
det_lp:field_ctr gt numfield(-):goto mkdtrec:
::tot_fields[field_ctr]=fieldval(-,field_ctr):
::field_ctr=field_ctr+"1"; goto det_lp:
mkdtrec:' ***mkdtrec***::
::detl_ctr="1":
dtreclp:' ***dtreclp***::
:detl_ctr eq "1":export_detail_rec=tot_fields[detl_ctr];
detl_ctr=detl_ctr+"1"; goto dtreclp:
:detl_ctr le
numfield(-):export_detail_rec=export_detail_rec{delim{tot_fields[detl_ctr];
detl_ctr=detl_ctr+"1"; goto dtreclp:
::out(1)=export_detail_rec:
::write out:
::return:
@done:::
::declare local ok_filename(75,*,g):
::ok_filename="G
"{bksl{"EXPORT"{bksl{"RECON_FILES"{bksl{@fi{".ok":
::export ascii wrt = (ok_filename) r=\n:
::wrt(1)="Total Records
"<@ts:
::write wrt:
::end:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130319/9c7121f5/attachment.html