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

[Roy Sigurd Karlsbakk]

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