Stan's slow problem [located?]

[Ruslan Zasukhin]

On 6/1/06 6:03 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> On 6/1/06 1:32 PM, "Stan Busk" <maxprog at mac.com> wrote:
> 
>> 
>> I have updated the DB (structure + classes) and I have reindexed. I
>> get a 3 seconds enhancement only.
>> It looks like there is something else...
> 
> Okay I know where is problem.
> 
>     Search on Boolean fields.
>     Transaction_Refunded, Transaction_ChargeBack.
> 
> They are marked as Indexed,
> But they do not have real index...
> 
> What I cannot understand, where are my algorithms to work on Boolean field.
> They have disappear ... Black magic.
> 
> Okay, know I know where to search for ...

I have find that change that did happens in 2.3:
    I have found that Boolean field do have index and disable
    creation of index for it.

Probably I have learn 1.x sources and have see that for Boolean field I did
have overridden search methods. And most probably I have forget implement
them for Boolean. 

As we see this step have drop down speed. And right - at least 32 times, may
be even 40 times looks to be true...

So issue not in COUNT() and not in SUM(), but in WHERE fldBool = xxx


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