Re: Realtime Bulk RDBMS Inserts?

From: Allen <allen.brost_at_motorola.com>
Date: 2000/05/04
Message-ID: <3911DC59.35FC8EEE_at_motorola.com>#1/1


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 Thu May 04 2000 - 00:00:00 CEST

Original text of this message