omi_at_chandiramani.org (Omi Chandiramani) said:
>In a nutshell, I am trying to compare performance between Oracle 9i,
>and MS SQLServer 2000, when programming in Java using JDBC. I'm
>noticing that Oracle is twice as slow as SQLServer, and am wondering
>if this large difference is a result of some mis configuration on my
>part.
...
>The databases are both installed on the above machine:
...
>Oracle 9i
>UTF-8 installation
>Enterprise Install / General Purpose db
>JDBC: Oracle 9i JDBC drivers from Oracle, Type 4
...
>Both databases were installed accepting most of the default settings
>except as noted above.
I really should take a look at 9i one of these days -- but pay
attention: the default install of 8i at least on any Unix-like system
can pretty much be considered a misconfiguration by itself. What needs
to be changed:
- default block sizes
- memory allocation parameters
... at the very least. Also the default tablespace storage parameters
could be improved.
--
Wolf a.k.a. Juha Laiho Espoo, Finland
(GC 3.0) GIT d- s+: a C++ ULSH++++$ P++@ L+++ E- W+$@ N++ !K w !O !M V
PS(+) PE Y+ PGP(+) t- 5 !X R !tv b+ !DI D G e+ h---- r+++ y++++
"...cancel my subscription to the resurrection!" (Jim Morrison)
Received on Sun Jan 26 2003 - 14:37:00 CST
