very slow lookup

[Richard Kreiss]

Yes, watched this with the debugger and when the lookup statement executed, everything just stopped. After some time the processing moved to the next line. 

Richard
Sent from my iPhone

> On Jul 10, 2014, at 1:07 PM, Kenneth Brody <kenbrody at spamcop.net> wrote:
> 
>> On 7/10/2014 12:20 PM, Richard Kreiss wrote:
>> I have a login routine that looks at a file call cstrack which has just
>> under 17,000 records.
>> 
>> The lookup is based on en(5,.0) in the login routine and looks to index A
>> in cstrack.
>> 
>> What the program gets to the lookup statement, it sits there for more the
>> 15 seconds and sometimes up to a minute.
>> 
>> This routine will counts the number of records(getnext) with that number
>> and displays the count prior to ending and running the proper user menus
>> based on the person's login name.
>> 
>> Any suggestions with what will cause the initial delay with this lookup?
>> 
>> When the file is accessed directly using index A, the records come up
>> right away.
> 
> Are you sure it's the actual lookup statement, and not your getnext loop 
> that takes all that time?
> 
> -- 
> Kenneth Brody
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list