[V4RB] Slow query comparing to v1.1

[Claudius Sailer]

Am 13.03.2006 um 19:22 schrieb Stan Busk:

> Hi,
>
> In a project I use the following SQL query many times at startup:
>
> SELECT Count(*)
> FROM myTable
> WHERE myField LIKE '%Q%'
> AND myField LIKE '%U%'
> AND myField NOT LIKE '%D%'
>
> Well, it is slow as a crawl. myField is an indexed VvarChar  
> (EVFlag.fIndexed). It takes 15 seconds to perform when it was  
> almost instantaneous with Valentina v1. myField contains a group of  
> 6 (up to 32) letters with no spaces to keep track of statuses.
>
> My question is, can this be optimized? or should I use now 6 (up to  
> 32) boolean fields to replace that design? I guess the best would  
> be a new EVFlag.fIndexedByChars modifier. Could it be possible?

INHO
could be RegEx faster?

I am not very frim with RegEx, but isn't it possible to take all in  
one statement?

bye


Claudius

-- 
iMac CD 2GHz / MacOS X 10.4de / RB 2006r1/ Valentina 2.1
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]