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

Michael Peppler <mpeppler_at_mbay.net> wrote:

>Josef Holzer wrote:
>>
>> 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.
 ...
>We had to write some specialized software to manage the flat files,
>but all in all it was a pretty fast and robust system.

If a C++ class library is an option, you could have a look at MetaKit:

        http://www.meta4.com/metakit/summary.html

It should be well suited for the performance level and amount of instrument data you have described. The relevant features of MetaKit here are that it offers portable and fail-safe data storage, and can handle nested data structures which can be help in achieving very compact and fast storage.

Feel free to contact me to discuss ideas for your particular situation, I have worked with scientific measurement data in the past (chromatography - thousands of samples, millions of data points) and might be able to offer some suggestions.

Regards,
Jean-Claude