[Asterisk-Users] OT : For the SQL gurus..

[Tilghman Lesher]

On Wednesday 12 November 2003 10:01, Roy Sigurd Karlsbakk wrote:
> > >Thanks everyone for your help on this..
> > >
> > >For those who are interested I have done some speed tests on
> > > these two queries (below) on my server and the results are..
> > >
> > >Test script of 1000 quieries..
> > >Query1 ("code" field not indexed) = 47.183s
> > >Query1 ("code" field indexed) = 45.731s
> > >Query2 ("code" field not indexed) = 109.321s
> > >Query2 ("code" field indexed) = 2.302s
>
> Tried fulltext indexing?

Fulltext indexing won't get you anything, considering that these
queries aren't searching for non-0-based-offsets in substrings.

-Tilghman