[V4RB] Slow query comparing to v1.1

[Stan Busk]

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

> On 3/14/06 4:56 PM, "Stan Busk" <maxprog at mac.com> wrote:
>
>> Hi,
>>
>> The database is 24.7MB
>> myTable contains 36,000 records.
>
> What is compressed size ?
>
>> As I said the same v1 database is much faster on this specific query,
>> actually you don't even have to wait.
>
> About REGEX.
>
> REGEX can allow you do single scan to get result, because it have OR |
>
>
> -- 
> 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