[V4RB] Slow query comparing to v1.1

Tue Mar 14 17:00:47 CST 2006

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]