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

[David Gomillion]

Hey,

> -----Original Message-----
> From: asterisk-users-admin at lists.digium.com [mailto:asterisk-users-
> admin at lists.digium.com] On Behalf Of WipeOut
> Sent: Wednesday, November 12, 2003 10:28 AM
> To: asterisk-users at lists.digium.com
> Subject: Re: [Asterisk-Users] OT : For the SQL gurus..
> 
> Andy Powell wrote:
> 
> >>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
> >
> >
> >_
> >
> 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..
> :)
> 
> Later..

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

> 
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users