In Oracle, if you run with parallel processing -- parallel query and
parallel DML, it is very easy to get to a throughput wait (provided you
don't get an I/O wait first if you're 0+1 and on fiber using at least 6
spindles and match the file system block to the DB block size, you can
alleviate this). Also, in Oracle 9i there is a new protocol for
communication with the server called VI -- and no, it's not the editor. It
stands for Virtual Interface. I'm the 9i Beta Tech Lead for my company, and
from what I can see, VI reduces throughput performance by around 40% of a
straight TCP/IP SQLNet.
I know, Off Topic -- but there is finally something mentioned that I know
about! ;-)
mike.
[EMAIL PROTECTED] wrote:
>Hey:
>
>Yeah pretty tough to do with Oracle. However the DB is on a decent sparc
>box with
>Fibre T3 storage Arrays. I have been able to get 100MB/Sec to the disk
>under
>certain conditions. Under some circumstances I'm doing batch updates that
>go quite
>fast. I'm pretty sure I can do at least 8MB on these inserts.
>
>Thanks,
>Glenn
>
>Jack Coates wrote:
>
>> On Tue, 26 Jun 2001 [EMAIL PROTECTED] wrote:
>>
>> > On Wed, 27 Jun 2001, Glenn A. Thompson wrote:
>> >
>> > > Hey:
>> > >
>> > > Anyone have any links on how LRP performs on specific platforms?
>> > > I picked up a couple remanufactured HP vectras 166 pentiums for $69.
>I
>> > > wanted to try to use them for portforwarding specific application
>> > > connections. Like say aconnection to an internal Oracle DB. Can
>something
>> > > like this sustain 100Mb speeds?
>> >
>> > Search the archives of linux-router at Geocrawler... there were a few
>> > attempts to quantify these things. If my (sometimes faulty) memory
>serves
>> > me well, then achieving 100Mb speeds would be on the challenging side
>of
>> > life, even assuming you do have PCI and good-quality bus-mastering
>NICs.
>> >
>>
>> x86 hardware will limit you, but your first question should be if the
>> DB and client app could really produce 100 Mbps.
>> --
>> Jack Coates
>> Monkeynoodle: It's what's for dinner!
>>
>> _______________________________________________
>> Leaf-user mailing list
>> [EMAIL PROTECTED]
>> http://lists.sourceforge.net/lists/listinfo/leaf-user
>
>
>_______________________________________________
>Leaf-user mailing list
>[EMAIL PROTECTED]
>http://lists.sourceforge.net/lists/listinfo/leaf-user
--
Michael McClure
[EMAIL PROTECTED]
_______________________________________________
Leaf-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/leaf-user
