[CLUE-Tech] Oracle on Linux in production?
Grant Johnson
grant at amadensor.com
Fri Feb 15 12:12:10 MST 2002
The numbers for MS on TPC-C are real, HOWEVER...... They are not real
world. Take a look at their clustering. It works like this:
1) They added the ability to reference databases on another server with
dot notation so that you can make a view actually pull data from
multiple servers.
2) They added the ability to make triggers on views so that you can
fake an update to a view.
That's it. You have to manually maintain all of the views. It is not
feasable in a production environment from what I have seen.
Also, rarely is OLTP performance a big problem with well designed tables
and indexes. Usually the problems are in joining a lot of stuff for
reporting. The king of that is DB2. It is even faster than Postgres.
More information about the clue-tech
mailing list