[V4RB] Slow query comparing to v1.1

[Stan Busk]

Actually, in that specific case it is:

'Q' AND 'U' AND NOT 'D'

so REGEX 'Q|U|D' will not return the result I am expecting.

Stan

> On 3/14/06 5:28 PM, "Stan Busk" <maxprog at mac.com> wrote:
>
>> SELECT Count(*)
>> FROM myTable
>> WHERE myField REGEX 'Q'
>> AND myField REGEX 'U'
>> AND NOT myField REGEX 'D'
>>
>> is right now almost twice as fast than
>>
>> SELECT Count(*)
>> FROM myTable
>> WHERE myField LIKE '%Q%'
>> AND myField LIKE '%U%'
>> AND myField NOT LIKE '%D%'
>>
>> 8' rather than 15'.
>
> Interesting.
>
> Try also:
>
> SELECT Count(*)
> FROM myTable
> WHERE myField REGEX 'Q|U|D'
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina