>Hi,
>
>I'm looking at a FOXPRO 2.5 program and it has a IF statement checking for FILE() on a network directory which has 97K files and another network directory that has 45K files, so basically something like this
>
>IF NOT FILE('x:\test\cust.dbf') AND NOT FILE('x:\test2\empl.dbf')
>
>but it can take from a minute to 10 minutes to check, is there any other method to speed up the process? I'm thinking there might be some network issues regarding the slowdown also but I'm going to do some time trials using ADIR maybe or some other command that might be faster.
>
>Any ideas?
>
>Thanks.
Try "reverse logic", it may be faster since it may skip the test faster, especially if you know which file is most likely to exist, and put it first.
IF !(FILE('x:\test\cust.dbf') or FILE('x:\test2\empl.dbf'))