Re: Oracle 8 vs Sybase Adaptive Server

Hello;

    Currently I am on a site that has over 20 transactions persecond on the most hit table using Sybase. No problem with it at all. But to say which one is better is very hard. The internal workings of Sybase and Oracle are the exact oppiste. Do you want internal or OS level threading? Sybaes avoids OS calls when ever possible. It even talks diretcly to the disk controllers. With user level threading, this gives you the ability to have multipuly engines, running multipuy threads. More interesting is that you can have several threads for each query. You can set priorities on users, or applications. Then you can bind them to a engine. This lets you get the most out of your hard ware. Also, this avoid alot of context switchs between processes.

    As for Oracle, I can not speak.

Steven Cruz

Paul Davies wrote:

> I'm building a web based application that is performance critical - it needs
> to process thousands of transactions per second.
>
> Can anyone tell me which would be more suitable for this type of
> application: Oracle 8 or Sybase Adaptive Server?
>
> Thanks
>
> Paul Das
Received on Sun Dec 27 1998 - 00:00:00 CST