From: "Clark Morrow" Subject: Re: Realtime Bulk RDBMS Inserts? Date: 2000/05/05 Message-ID: <8evtjt$6ibc$1@node17.cwnet.frontiernet.net>#1/1 References: <8ef0eq$t6l$1@nnrp1.deja.com> <3911DC59.35FC8EEE@motorola.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Complaints-To: abuse@frontiernet.net X-Trace: node17.cwnet.frontiernet.net 957577661 215404 209.130.219.69 (6 May 2000 01:47:41 GMT) Organization: Frontier GlobalCenter Inc. X-MSMail-Priority: Normal NNTP-Posting-Date: 6 May 2000 01:47:41 GMT Newsgroups: comp.databases.olap The standard Oracle SQL*loader can do "direct loads." Later versions of Oracle 8i also have a direct path load API. "Allen" wrote in message news:3911DC59.35FC8EEE@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@home.com > > remove nospam from reply address > > http://24.8.218.197/ > > "Offshore Solutions" wrote in message > > news:8ef0eq$t6l$1@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@bluebaysoft.com > > > http://www.bluebaysoft.com > > > > > > > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. >