very slow lookup

[Richard Kreiss]

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.

Richard Kreiss
GCC Consulting



-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 8341 bytes
Desc: not available
Url : http://mailman.celestial.com/pipermail/filepro-list/attachments/20140710/8168d1b8/attachment.bin