thread182-1367839
Try these items:
1 Place all indexes in CDX file.
1 Index on each field being used by the SELECT.
2 Also index on deleted() as deleted.
3 Do not use compound indexes on the file.
4 Have all temp work files assigned to local drive (C
5 Have a copy of the library FOXDX260.ESL on local drive
6 Have FOXDX260.ESL as a locked file.
7 Data file does not have to be open BUT available on path
8 Have the clock off
For those coming late, I hope this helps....
Try these items:
1 Place all indexes in CDX file.
1 Index on each field being used by the SELECT.
2 Also index on deleted() as deleted.
3 Do not use compound indexes on the file.
4 Have all temp work files assigned to local drive (C
5 Have a copy of the library FOXDX260.ESL on local drive
6 Have FOXDX260.ESL as a locked file.
7 Data file does not have to be open BUT available on path
8 Have the clock off
For those coming late, I hope this helps....
