Re: Query speed

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 09 Apr 2001 13:30:43 GMT
Message-ID: <7QiA6.696997$U46.21791575@news1.sttls1.wa.home.com>

It is going to depend upon a lot of factors. Are you using host variables and not reparsing statements? What IO limits does your disk system have? What bandwith limits do the NIC's have? What type of queries? What OS? You can get a lot of queries out of Oracle, but it isn't as simple as your question.
Jim

"Jonathan Kukin" <jonathan.kukin_at_aptonix.com> wrote in message news:E20C627AB7F6D4118C4200508BB3C49A60D60E_at_tpa-mail1.telradnetworks.co.il.. .
> Hello.
> I'd like to check the possibility to use Oracle DB in my application.
> I have some questions:
> 1. How many search queries per second can be handled?
> 2. What factors have the most influence on this parameter?
> 3. Does Search time depends on size of DB, or on number of entries, or on
> indexes, or query length or on OS or something else?
>
> Thanks a lot for a quick response.
> Jonathan Kukin
>
>
> --
> Posted from [62.90.58.17]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Apr 09 2001 - 08:30:43 CDT