Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only