[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