>Hi,
>As stated in a previous message it was only to test how rushmore did it's index matchup and check if any changes in VFP9 had made any difference.
>
>BTW on 10mil records the DELETED() binary index adds about 0.02secs to the run.

I doubt that would be the case over a 10 MB LAN. It has to pull the data from the CDX to the workstation. 10 million bits is 1.220 megabytes. No problem for a local hard drive or a gigabit NIC.


>
>>>>Do you have an index on ALLTRIM(BATCHNO)? I think we should avoid ALLTRIM in index expressions like plague.
>>>
>>>Yes, Not duplicating the index statement exactly in the SQL clause causes greatly reduced performance. i.e. using just BATCHNO when the index is ALLTRIM(BATCHNO) will not optimize.
>>
>>You should not use ALLTRIM() in indexes. Far better to INDEX ON PADR(ALLTRIM(BATCHNO),10) and then to SELECT WHERE PADR(ALLTRIM(BATCHNO),10) = "batchno "
>>
>>>
>>>Also getting the SET EXACT and SET ANSI settings correct also impacts greatly.
>>>
>>>Rushmore is a great piece of technology, once you understand it.