Re: Informix and Oracle in the same shop

In article <5n4e5a$qk5@cssun.mathcs.emory.edu>, rambabu@sprynet.com writes: > I have been following this thread for quite sometime and I believe > nothing runs "concurrently", not even the unix processes(it just > schedules them). IRIX is multithreaded therefore a parallel process can run concurrently. > 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". > Err... this point is debatable... I contend that it's not as efficient however short of doing an actual execution I can't prove that. I don't believe that an RDBMS vendor can do as well as a hardware vendor. The RDBMS vendor's codeline is as generic as possible -- generic == not as efficient. If it wasn't generic and was truly hardware vendor specific, imagine the maintenance nightmare. Food for thought... Btw, Johnathan Leffler sent me personal e-mail saying that he was dropping out of this conversation 'cuz he had lack of information not... I respect that... quite a bit actually. Take care. -- 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