another -v processing question

[Dennis Malen]

Ken,

I scan through the file using the -v. As the file was getting larger and 
larger it was taking very long to finish up. Select was used to pull the 
file.

In answer to your question, I wasn't expecting anything except for what I 
was getting. I posted the question to see if anyone was aware of how to take 
advantage of an auto index in the -v processing. My question was answered by 
a number of responders on the list including you.

The suggestion provided now allows me to take advantage of the automatic 
index so the processing now is almost instantaneous.

Wonderful suggestion.

I'm not sure what more you are looking for Ken. Pretty simple stuff.

Any further questions give me a buzz or if you want me to call you let me 
know. No need to take up the time of those on the list.

Thanks!
Dennis Malen
516.479.5912
----- Original Message ----- 
From: "Kenneth Brody" <kenbrody at spamcop.net>
To: "Dennis Malen" <dmalen at malen.com>
Cc: "'FilePro Mailing List'" <filepro-list at lists.celestial.com>
Sent: Monday, June 08, 2009 9:41 AM
Subject: Re: another -v processing question


> (Top-posting corrected, again.)
>
> Dennis Malen wrote:
> [...]
>>> [...]
>>>>>> If there were some way within processing or on the command line to 
>>>>>> identify an automatic index to use and -v would recognize this it 
>>>>>> would save a tremendous amount of time. Using -v takes longer and 
>>>>>> longer as the file grows.
>>>>> [...]
>>>>>
>>>>> I'm not sure I understand what you are asking.  Once this index were 
>>>>> specified, are you expecting this to magically tell filePro to access 
>>>>> only those records that your processing wants?  All that specifying an 
>>>>> automatic index as input does is cause filePro to read the records in 
>>>>> index order, rather than record number order.  What functionality are 
>>>>> you envisioning here?
>>>>>
>>>> No, as long as the scan in -v will use the auto index then fine.
>>>
>>> I still don't understand what you expect to "magically" happen.  What do 
>>> you mean by "the scan in -v will use the auto index"?  There is no "scan 
>>> in -v".
>> That's the point Ken. I was not able to use the automatic index to speed
> > up the processing.
>
> What, exactly, did you try that "didn't work"?
>
> > With Nancy's suggested fix, that should make use of
> > the auto index.
>
> Which is exactly what I said in my first reply -- use the "-i" to specify 
> an automatic index, and then use lookup-dash on that index to move around 
> in the file.
>
> > My scanning the file required me to start from the beginning and go to
> > the end.
>
> What, exactly, did you do?
>
> > With Nancy's work around I will now be able to take advantage
> > of the auto index and speed up the selection of records no matter how
> > large the file is.
> >
> > Hope that answers your question.
>
> You still haven't answered the question about what you expected to do that 
> would "magically" cause filePro to know which records you wanted.
>
> -- 
> Kenneth Brody