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

WipeOut wipe_out at onetel.com
Wed Nov 12 09:27:30 MST 2003


Andy Powell 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
>>
>>    
>>
>
>OUCH! those times are loooooooooooong!
>
>Andy
>
>
>_
>
I agree the first three are long, but the last one works out to just 
over 26000 queries per min.. I didn't think that was bad for a PII 350.. :)

Later..





More information about the asterisk-users mailing list