Re: Realtime Bulk RDBMS Inserts?
From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/03
Message-ID: <qa0Q4.169543$Tn4.1240338_at_news1.rdc2.pa.home.com>#1/1
Date: 2000/05/03
Message-ID: <qa0Q4.169543$Tn4.1240338_at_news1.rdc2.pa.home.com>#1/1
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...Received on Wed May 03 2000 - 00:00:00 CEST
> 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.