Performance and reliability of c-tree vs. Sybase or Oracle

I am currently using a c-tree (Faircom) database for collecting pricedata of fiancial instruments. As I want to improve the reliability of the database as well as to increase the number of datarecords, I would like to move to a more robust database like Sybase or Oracle. But I do not want to lose performance compared to my existing c-tree database that also runs fine on a desktop computer.

The database should be able to store about 50.000 instruments that have updates between 1 and 10.000 records per day (some instruments even more often). At some peak times the database has to handle about 1000 updates per second.
To handle such update frequencies I have implemented some caching as well as buffering: I store blocks of small price records (Instrument, Time, Last, Vol) in one database record.

The structure of the tables are very simple: (Instrument, Time, Last, Vol).
No complex queries are required. The most often used transactions are: 1) Append new price record (up to 1000 per second) 2) Get a large block of price records of one instrunent.

Could anybody tell me, if this kind of task can be done by a Sybase or Oracle database with the same performance as by a c-tree database or even better?
Do I have to take care of some special design considerations?

Thanks for your help

Josef
email: holzer_at_teletrader.com Received on Mon May 26 1997 - 00:00:00 CEST