Re: Inserts into database

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 11 Apr 2001 23:38:22 -0700
Message-ID: <3AD54D5E.8EDABEB6@exesolutions.com>

I can't imagine anyone being able to give you a number that would have any meaning. There are far too many variables from indexes to constraints to the efficiency of your code, to network traffic and on and on and on.

Daniel A. Morgan

Iain Wiseman wrote:

> 1) How many records can an HP workstation 3000 bytes/record
>
> CPU 300MHz
> Memory 256.2MB
> 2 X 10,000 rpm
>
> running oracle 8.0.6
>
> We are doing batch inserts of 600 in procc and there are no triggers.
>
> 2) Can I make these discrete transaction in proc. (Not using BEGIN END)
>
> Thanks
>
> Iain
Received on Thu Apr 12 2001 - 01:38:22 CDT