A
faster database may complete the blocking transaction faster, but your transaction is
still at a dead stop until the blocking transaction completes.
Because most databases perform a mixture of reading and writing, and because Oracle
is one of the only databases on the market that doesn??™t use read locks, Oracle will
essentially always deliver the lowest amount of database contention. Less contention
equals greater throughput for a mixed application load.
There is also more than one type of performance. Performance for database operations
is measured in milliseconds; performance for application developers is
measured in months. Because Oracle provides much less contention with its read
consistency model, developers have to spend less time adding workarounds to their
applications to handle the results of contention.
It??™s not as though Oracle is the only database to give you a concurrency solution you
can use to implement applications that provide adequate data integrity. But the multiversion
read consistency model makes it easy for youto get a consistent view of
data without excessive contention and without having to write workarounds in your
application.
Pages:
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442