[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
>>
>
> OUCH! those times are loooooooooooong!

Can I have a copy of this database? It'd be cool to see what can be 
done to tune it :)

roy