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

[WipeOut]

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?
>
>  
>
Due to the nature of the search I don't think it would have benefitted 
from fulltext indexing..

Later..