Re: Informix and Oracle in the same shop

I have been following this thread for quite sometime and I believe nothing runs "concurrently", not even the unix processes(it just schedules them). What Informix I believe it does is, shifting the 'would've been individual processes (threads)' to its control and scheduling them by putting the threads in a process. The context-switching with in a process, between threads is "more efficient" and "database centric". Vijay R. Anisetti Pablo Sanchez wrote: } } 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