Re: relational vs. oo dbms performance

Hi Ken,

Ken schrieb in Nachricht ...
>What is the general consensus out in the community about the performance
>issues between the two?

if both databases are held completely in the main memory, I'd favour the object oriented database, since the latter is easier to program. But normally, databases dont't fit into the core.

The fundamentals of implementing database systems: for a hard disk controller, it makes no difference whether to read one bit or a kilobyte.

Relational database systems make use of this effect by providing set oriented operations. A table is a set of records that are optimized to lay physically at the same pages on disk.

Objects in object oriented databases are often structured and consist of sub-objects and spread data. If you access one single object, you probably suffer a couple of page reads.

Regards,
Joachim

--
Answer the keima with a kosumi.
(Go proverb)