Re: Query speed

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 09 Apr 2001 22:14:17 +0100 (BST)
Message-ID: <rUB*kMiTo@news.chiark.greenend.org.uk>

Jonathan Kukin <jonathan.kukin_at_aptonix.com> wrote:
>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?

I've seen Oracle manage well over a hundred thousand queries per second, in a real application.

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

How long is a piece of string? It depends on everything.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/

Received on Mon Apr 09 2001 - 16:14:17 CDT