>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
_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
