[ALL] Second project... Optimizations

[Ruslan Zasukhin]

On 7/15/06 1:18 PM, "Stan Busk" <maxprog at mac.com> wrote:

>> --------------------------------------------------------------
>> 2) So at first you count number of articles in thread, then you
>> count number
>> of UNREAD articles in this thread.
>> 
>> I wonder, why you use
>>                 Article_Status LIKE '%U%'"
>> 
>> Why String search? Why LIKE search ? Why not just Vboolean field ?
> 
> Because articles has around 10 different states.
> 
>    U = Unread         (old 0)
>    R = Read           (old 1)
>    D = Deleted        (old 2)
>    A = Archived       (old 3)
>    S = Sent           (old 4)
>    Q = Queued
>    P = Purge
>    L = Log
>    F = Followed-up
> 
>    For example: RA = Read and archived
>                 RD = Read and deleted
> 
> Status is 32 bytes so it can contain much more stuff. I choose this
> design because it worked really fast with v1.

Okay, I see.

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