[V4RB] Slow query comparing to v1.1

[Ruslan Zasukhin]

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]