[V4RB] Slow query comparing to v1.1

[jda]

>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'
>

I have reported on Mantis that NOT searches are quite slow in V2...

Jon