>Oracle does have a higher overhead which makes it slower for read-heavy
>apps, but the benefit is that Oracle can sustain extreme levels of
>read-write concurrency without contention. With Oracle, you can have, say,
>50 different threads writing rows to a table simultaneously while another
>200 threads read the same table, and all with out any significant
>contention or lock waits. Reads are never blocked by writes. Anytime you
>have a fair amount of writing and lots of users, Oracle will shine (as it
>should since that is what it is designed to do). The Oracle kernel is
>designed to reduce contention to the minimum possible levels even under
>heavy write loads; a user wanting to read a record will not notice a wait
>or a significant performance loss due to a large number of threads writing
>the same table or even the same row. Even pathological cases are handled
>gracefully.
I certainly don't want to start a flamewar over something silly like this, but
I just cannot let this particular paragraph (and especially the last sentence)
go by without one comment:
Not In My Experience.
--
derick