Randy,
You mentioned that Informix may be a little faster...
Well I got news for you dude, Informix has pretty much always been faster!!!
I did some contracting at IBM about 5 or 6 years ago, my job was to write TPC-C benchmarks for Oracle on the RS/6000's, (they were pretty new then), I worked side by side with an Informix programmer doing the same thing, Informix's benchmarks were indeed faster, but here is the reason:
Informix's engine is much more basic, keeping little or no internal statistics, about the kernel, or the individual process's...
Oracle keeps considerable amounts of internal statistics, dealing with EVERY single database operation that is talking place....
Yes this causes a little overhead, which may leave it a little slower, but it also provides a mechanism to track, and report on everything that is happening within the database at any given time, this is useful in debugging, tuning, reporting, etc.
This has been the case for quite some time, hell I could write a database engine which would just push thru transactions, but which would you rather have????
Ernie |
