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

[Peer Oliver schmidt]

Hi David,

>>>>For those who are interested I have done some speed tests on these
>>>>Test script of 1000 quieries..
>>>>Query2 ("code" field indexed) = 2.302s
>>>OUCH! those times are loooooooooooong!
>>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
[..]
> 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...

you might want to re-read the results:

1000 queries = 2.302s

For me this looks like 2ms per query.

Maybe WipeOut can confirm the information (one way or another)
--
Best regards

Peer Oliver Schmidt
the internet company