Re: Oracle performance under NT

From: <mpir_at_compuserve.com>
Date: Mon, 07 Dec 1998 22:42:31 GMT
Message-ID: <74hlkn$dai$1@nnrp1.dejanews.com>

I am not sure if there is a simple answer.

40 inserts per second=3,456,000 inserts per day.

On one of our slow NT servers, I just used SQL*LOADER for 18M inserts in about 20 minutes. I have a test program that does some timings that loops an insert and does about 4M per hour.

The issue is how are the inserts coded, are there any indexes, etc.

In article <74g81b$qf0_at_romeo.logica.co.uk>, "Stephen Vear" <vears_at_logica.com> wrote:
>
> Does anybody have any performance statistics for Oracle running on NT ? We
> are considering a system that will have to perform about 40 table inserts
> per second for a period every day. The inserts are about 6 attributes each.
> We basically want to know whether this sort of performance can be achieved
> on an NT platform, or if we need to look to Unix.
>
> Any case histories are appreciated
>
> Stephen Vear
> vears_at_logica.com
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 07 1998 - 16:42:31 CST