David,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
I disagree with your disagreement :P We have to keep in mind the big picture. We are providing dial tone. I don't want to have to wait an extra 2.302 seconds for my call to be set up. Also, think of the big organizations: if you have 200 phone calls, and you have each one take even a couple of seconds extra, you are going to have to add more lines...
Please read again.. it was 2.3s for 1000 queries being run in a loop one after the other.. that means about 0.0023s for 1.. so you would get your dialtone pretty quick!!.. :)
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
