Re: Realtime Bulk RDBMS Inserts?

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: 2000/05/07
Message-ID: <3915404D.56AA157B_at_csgsystems.com>#1/1


It is an option of sqlloader. In the parfile or on the command line it looks like:

    direct=true

Allen wrote:

> 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 Sun May 07 2000 - 00:00:00 CEST

Original text of this message