<snip>

>If you're not convinced that SYS(3054) is telling the truth, or if you think the integer field used above is a special case for some reason, use some other table. You may have to use a table with > a million records to see the difference, but you will see it:
>
>

>ACTIVATE SCREEN
>CLEAR
>
>USE priceanalysis
>* a table with 1.5 million records,
>* with an index on artform
>s = SECONDS()
>COUNT FOR artform = "L"
>s1 = SECONDS()
>COUNT  FOR "L" = artform
>s2 = SECONDS()
>
>? "with rushmore:", s1-s
>? "without rushmore:", s2-s1
>

Hi Lisa, this is not true, first and second are optimized.

With == comparison this is true, first optimized, second no optimized.

ACTIVATE SCREEN
CLEAR

USE priceanalysis
* a table with 1.5 million records,
* with an index on artform
s = SECONDS()
COUNT FOR artform == "L"
s1 = SECONDS()
COUNT  FOR "L" == artform
s2 = SECONDS()

? "with rushmore:", s1-s
? "without rushmore:", s2-s1

<snip>

Fabio