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

[WipeOut]

David Gomillion wrote:

>>>>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...
>
>  
>
David,

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!!.. :)