Hey, > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:asterisk-users- > [EMAIL PROTECTED] On Behalf Of WipeOut > Sent: Wednesday, November 12, 2003 10:28 AM > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
