I am having a DBF named MJOB.dbf with 20000 records. The table has
indexes on the following fields:-
JOBNO
JOBDATE
JOBSERIES
I have also indexed on Deleted() as set deleted in on. However, the
following select-sql takes around 6-8 seconds when executed from a
workstation.
***Code***
Select max(JOBNO) from MJOB ;
where SERIES='A' and Between(JOBDATE,mFDate,mTdate) ;
into array mARray
Return mArray
I tried out several things and later the following proved to be more
quicker. (It takes less than 1 sec)
**Code**
Select JOBNO from MJOB ;
where MJOB.SERIES='A' and Between(MJOB.JOBDATE,mFDate,mTdate) ;
order by 1 ;
into cursor c1
Select C1
Go Bottom
Return C1.Code
Is MAX() function not optimized by RUSHMORE or is there any other
mistake in my 1st code.
Kindly guide.
Rajeev