Re: Informix and Oracle in the same shop

In article <OjmGEAATwJlzEwOO@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes: > >o Informix isn't threaded because you have all 'em VP's running out > > there. They aren't in the same execution space. They have their > > own and thus there is *some* context switching. Of course Oracle > > has a process for *everything* so that's taking context switching > > to the max. > > So how do you get >1 CPU used simulatanously if you one have one UNIX > process. I know that this may sound patronizing but really that's not my intention... consider reading Threads Primer by Bil Lewis/Daniel J. Berg ISBN 0-13-443698-9, it does a much better job than I can ever do to explain how a single process (multithreaded) can run in a single processor environment as well as in a multiprocessor environment. How system calls that perform I/O, if they are thread-safe, can handle the concerns that you list, how multiple threads within a process can run *concurrently*. That's the type of threading I'm talking about. Don't believe the (vendor) hype. -- Pablo Sanchez | wk: 415.933.3812| pg: 800.930.5635 -or- pablo_p@pager.sgi.com --------------+-----------------+-------------------------------------------- pablo@sgi.com ... when mailing me, place "not spam" in the Subject