Hi Donna,
Donna Robinson wrote:
>Hi Jeremy,
>
>On Sunday 05 May 2002 5:52 am, Jeremy Zawodny wrote:
>
>>REGEXP queries don't use indexes. Change the:
>> REGEXP "^A"
>>to
>> LIKE "A%"
>>and it'll use the index and give you a nice speed boost.
>>
>
>which indeed it did! I checked the manual (yet
FilterFodder: sql, query
Yo Jeremy,
On Sunday 05 May 2002 9:31 pm, Jeremy Zawodny wrote:
> That one isn't fixed as easily. ...
> You might be able to use a BETWEEN query:
(eyes raised to heaven, hands clasped in prayer)
o jeremy you are my hero!
(grin)
seriously, thanks a lot, i really apprec
On Sun, May 05, 2002 at 04:54:41PM +0100, Donna Robinson wrote:
> Hi Jeremy,
>
> On Sunday 05 May 2002 5:52 am, Jeremy Zawodny wrote:
> > REGEXP queries don't use indexes. Change the:
> > REGEXP "^A"
> > to
> > LIKE "A%"
> > and it'll use the index and give you a nice speed boost.
>
> which
Hi Jeremy,
On Sunday 05 May 2002 5:52 am, Jeremy Zawodny wrote:
> REGEXP queries don't use indexes. Change the:
> REGEXP "^A"
> to
> LIKE "A%"
> and it'll use the index and give you a nice speed boost.
which indeed it did! I checked the manual (yet again) and it doesn't actually
say anythin
On Sun, May 05, 2002 at 03:21:59AM +0100, Donna Robinson wrote:
>
> explain select dances.danceid, dancetitles.title from dances,
> dancetitles where dances.danceid=dancetitles.danceid and
> dancetitles.title regexp "^A" and dances.has_desc='T' order by
> title;
[snip]
> This is TERRIBLE! But
