Re: Query speed

From: Robert Spikol <bspikol_at_home.com>
Date: Tue, 10 Apr 2001 02:36:34 GMT
Message-ID: <SkuA6.36450$Os.7958648@news1.rdc2.pa.home.com>

All factors may be important. IMHO, the disk subsystem is rather important. You need to spread tablespaces across as many disks as possible in order to get parallel I/Os.

The database I work with supports (indirectly) up to 1,000,000 users who cause small transactions to occur.
"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 - 21:36:34 CDT