very slow lookup

[Kenneth Brody]

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