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