Re: Realtime Bulk RDBMS Inserts?

I am talking about direct mode / load same thing. It is also accessable through some stored procedures, but I have to admit, I have never done it.

Direct load is available for either imp or sqlldr.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Allen" <allen.brost_at_motorola.com> wrote in message
news:3911DC59.35FC8EEE_at_motorola.com...


> How did you do that?  Is the direct load a separate application?  I have


> not heard of that before.  That sounds a lot faster than importing using

> direct mode or is this what you are talking about.

>

>

>

> Bob Fazio wrote:

>

> > I just did a load in a partition table where each partition hold roughly

 40


> > Million records.  Using oracle's

> > Direct load option was able to load close to 3000/sec.  approx 200bytes


 per


> > record.


> >

> > --

> > Robert Fazio, Oracle DBA

> > rfazio_at_home.com

> > remove nospam from reply address

> > http://24.8.218.197/

> > "Offshore Solutions" <projects_at_bluebaysoft.com> wrote in message

> > news:8ef0eq$t6l$1_at_nnrp1.deja.com...

> > > Looking for any white papers, discussions, links, topologies or

> > > descriptions of solutions that are capable of handling large-scale

> > > real-time insertion of data into RDBMS. Granularity would be

 sub-second


> > > and capable of handling 10,000 to 15,000 rows a second in total,

> > > round-robined from several different feeds. Cacheing is obviously

> > > required. Any constructive thoughts appreciated!


> > >

> > > --

> > > Projects Department

> > > Email:projects_at_bluebaysoft.com

> > > http://www.bluebaysoft.com

> > >

> > >

> > > Sent via Deja.com http://www.deja.com/

> > > Before you buy.

>