RE: OT RE: Async I/O on Windows

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Mon, 05 Feb 2001 13:57:35 -0800
Message-ID: <F001.002AB1B7.20010205124535@fatcity.com>

Yay,
someone is looking at the data....!!!

On the
clustered side, did you notice that the leader, far and away, was SS2K on Win2K.

Pure
Microsoft Play, and clustering 192 CPUs. WOOOOO-WAAAAAAA. 
too
bad "Microsoft can't cluster" ( har de har har )

-----Original Message-----From: Jeffery Stevenson [mailto:jeff_at_mpv.com]Sent: Monday, February 05, 2001 1:06 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows
 Well, Oracle does
 have all three of the top spots in TPC-C for Non-clustered results...I wonder how a performance/square foot rating would turn out...hmmm...
 
 :)

Jeffery StevensonChief Databeast TamerMedical Present Value, Inc.Austin, TX

-----Original Message-----From: Mohan, Ross [mailto:MohanR_at_STARS-SMI.com]Sent: Monday, February 05, 2001 9:56 AMTo: Multiple recipients of list ORACLE-LSubject: OT RE: Async I/O on Windows
"NT still pants"...LOL!!!

<SPAN

 class=176484515-05022001>It must be panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running

SQLServer on NT, as has DB2.

The general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org.

Check out the Top Ten TPC-C marks, by pure performance.


Not interested in pure peformance? Check out the Price/Performance leaders. Oracle doesn't
even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our illusions....

Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out ANY
 of
 the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even show
up.

 I
 mean, I like Oracle, too, but....by the time you turn on the multimode airconditioner, use
the 12-way adjustable power bucket seats, activate the object-oriented OnStar Satellite
navigational system, power up the heated side view mirrors and all the other tools, trinkets,
and toys that make it my personal favorite database, there *is* the chance that the
twenty year old genius mechanic in the the tricked out Nova next to you at the light is going to
 kick your ass when the light turns
 green.

But really, I still love Oracle. Warts and all.

Wanna drag?

(heh heh heh)





      <FONT face="Times New Roman" 
      size=2>-----Original Message-----From: Mark Leith 
      [mailto:mark_at_cool-tools.co.uk]Sent: Saturday, February 03, 2001 
      6:45 AMTo: Multiple recipients of list 
      ORACLE-LSubject: RE: Async I/O on Windows
      <SPAN 
      class=681293710-03022001>I have actually been doing a fair it of reading 
      on this since the topic was brought up, and stand corrected, as earlier 
      mentioned. But I have to say guys that NT is still fairly "pants" when it 
      comes to handling multi threaded processes.. Win2K is a great improvement 
      but M$ still has a lot of work to do on in my view. (only when you compare 
      this against UNIX) 
      <SPAN 
      class=681293710-03022001> 
      <SPAN 
      class=681293710-03022001>Now don't get me wrong, there is enough traffic 
      on this list about this at the moment, so I dont want more bandwith added 
      with this thread if at all possible :)
      <SPAN 
      class=681293710-03022001> 
      <SPAN 
      class=681293710-03022001>Thanks for the reply anyway Yong, I think I will 
      wait for a "good" book on Win2k to come out (unless you know one?) before 
      I go out and buy one (books come out of my pocket as I am a sales 
      person mostly).. NT as far as I am concerned is now in Win2K's shadow, and 
      I think that is the way of the future for Windowze bound 
      people.
      <SPAN 
      class=681293710-03022001> 
      <SPAN 
      class=681293710-03022001>For all out there that have used NT and not Win2K 
      - TRY IT.. Services are handled a LOT better, file management and 
      sharing.. All sorts of new fun stuff to sink your teeth in to.. 
      
      <SPAN 
      class=681293710-03022001> 
      <SPAN 
      class=681293710-03022001>As a side note, for the last line of my first 
      paragraph - I also feel that UNIX cannot be compared in anyway 
      to Windows at this time. Windowze O/S's are designed for pointy 
      clicky people that prefer to look at a nice GUI interface, and generally 
      don't have the indepth technical knowledge that a good UNIX sys admin 
      does.. 
      <SPAN 
      class=681293710-03022001> 
      <SPAN 
      class=681293710-03022001>(If there any NT admins out there don't flame me, 
      I have to deal with it every day of my life...)
      <SPAN 
      class=681293710-03022001> 
      <SPAN 
      class=681293710-03022001>Regards
      <SPAN 
      class=681293710-03022001> 
      <SPAN 
      class=681293710-03022001>Mark
      <SPAN 
      class=681293710-03022001> 
      <SPAN 
      class=681293710-03022001>The views expressed here are soley those coming 
      out of my coffee deprived hungover mind.. They do not express those of my 
      employers, though I'm sure they agree :^)
      
        <FONT face=Tahoma 
        size=2>-----Original Message-----From: root_at_fatcity.com 
        [mailto:root_at_fatcity.com]On Behalf Of Mohan, RossSent: 
        Friday, February 02, 2001 07:00To: Multiple recipients of 
        list ORACLE-LSubject: RE: Async I/O on 
        Windows
        Oracle on NT runs as 
        ONE PROCESS 
        with 
        MULTIPLE THREADS 
        for performance reasons (no more <FONT 
        size=2>need for shared memory....context switches <FONT 
        size=2>are a LOT less expensive, etc.) 
        -----Original Message----- From: 
        yong huang [<A 
        href="mailto:yong321_at_yahoo.com">mailto:yong321_at_yahoo.com] 
        Sent: Friday, February 02, 2001 12:51 PM 
        To: Multiple recipients of list ORACLE-L 
        Subject: Async I/O on Windows 
        Hi, Mark, 
        Async I/O is available on Windows, at least NT. It's not 
        an easy topic. If you think you already know 
        enough about operating systems in general, I suggest you 
        read David Solomon's "Inside WindowsNT". For a lab 
        test, launch Performance Monitor on your NT box 
        and look at the counters for Cache. 
        I'm not sure by "single thread management" whether you 
        mean NT can't have multiple processes or Oracle 
        on NT runs as one thread. The former is obviously <FONT 
        size=2>wrong. The latter is a design issue inside Oracle Corporation and 
        the question as to why was asked on this forum 
        before without an answer (without an answer I <FONT 
        size=2>can remember, that is). 
        Yong Huang <FONT 
        size=2>yong321_at_yahoo.com 
        you wrote: 
        Asynch I/O on a Windowze box? supresses a 
        snigger... 
        To the best of my knowledge there are no Windows based 
        system that can take advantage of this, single 
        thread management can be enough a problem <FONT 
        size=2>sometimes.. 
        But, I may be wrong.. List? 
        <FONT 
        size=2>__________________________________________________ 
        Get personalized email addresses from Yahoo! Mail - 
        only $35 a year!  <A target=_blank 
        href="http://personal.mail.yahoo.com/">http://personal.mail.yahoo.com/ 
        -- Please see the official 
        ORACLE-L FAQ: <A target=_blank 
        href="http://www.orafaq.com">http://www.orafaq.com <FONT 
        size=2>-- Author: yong huang <FONT 
        size=2>  INET: yong321_at_yahoo.com 
        Fat City Network Services    -- (858) 
        538-5051  FAX: (858) 538-5051 San Diego, 
        California        -- Public Internet 
        access / Mailing Lists <FONT 
        size=2>-------------------------------------------------------------------- 
        To REMOVE yourself from this mailing list, send an 
        E-Mail message to: ListGuru_at_fatcity.com (note 
        EXACT spelling of 'ListGuru') and in the message 
        BODY, include a line containing: UNSUB ORACLE-L <FONT 
        size=2>(or the name of mailing list you want to be removed from).  
        You may also send the HELP command for other 
        information (like subscribing).

Received on Mon Feb 05 2001 - 15:57:35 CST