Re: Realtime Bulk RDBMS Inserts?

The standard Oracle SQL*loader can do "direct loads." Later versions of Oracle 8i also have a direct path load API.

"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.
>
Received on Fri May 05 2000 - 00:00:00 CEST