Stan, I have found interesting solution for you.

[Ruslan Zasukhin]

On 7/16/06 9:34 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> 
>> 3) I have made Export/Import of field Article_Newsgroup into new v1
>> database. To see how much take v1
>> 
>>     v1 takes on this data and query   0.02 second.
>>     v2 now takes                      0.10 sec on default.
>>     v2 with disabled ICU collator     0.05 sec on default.
> 
> So having v1 you have LIKE searches of kind
> 
> SELECT Article_Newsgroups
> FROM tblArticle 
> WHERE Article_Newsgroups LIKE '%,alt.comp.shareware,%'
> 
> In 0.02 second.
> 
> I have found for your database query kind which do answer 10 times faster!
> In 0.002 second

Aha, this is time on DEBUG libs.

For RELEASE even better!

    0.0013


15 times faster of 1.x query.


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