Re: Speedy insertions in Database

From: Karen Abgarian <karen.abgarian_at_fmr.com>
Date: Thu, 19 Aug 1999 11:45:29 -0400
Message-ID: <37BC2699.DBB3459E@fmr.com>

Hi Mahavir

I dont believe anyone has exact numbers, as they would vary very much depending
on the operating system parameters, db configuration or the speed of IO drive.

If you have to do many insertions per second and if the speed is not acceptable, there
is a number of ways to speed it up by means of database. If it does not seem to work,
consider storing data in an OS file first and then loading it using SQL*Loader DIRECT
PATH. The same mechanism is available by using a new Oracle8 feature: APPEND
hint.

Regards,
Karen Abgarian.

mdkarnavat_at_hss.hns.com wrote:

> Hi there !
>
> I wanted to know the maximum number of "insertions per second" that can
> be made in an existing oracle database. A tuple may be of the size of
> around 200 bytes. The platform could be pantium II running Windows NT
> OS.
>
> Thanks and regards,
> Mahavir.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Aug 19 1999 - 10:45:29 CDT