This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle vs SQL Server with J2EE

 
Sunit Mukherjee
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does anyone know of any reliable comparisons of JDBC performance using Oracle JDBC driver vs SQL Server JDBC driver? We are trying to evaluate reasons for going with Oracle vs SQL Server.
Thanks!
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can be sure that there will be much busier sites than yours which run both.
The technical abilities of your staff should be a more important factor.
(or security even)?

my $0.02
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I wouldn't say there are much differences in the JDBC driver regarding performance (talking about pure JDBC driver). The biggest difference should happen in the DB itself.
For Oracle there exists also an OCI driver (native) which can be called from java. This driver increases performance immens.
The other thing is also which machine are you running your db. Oracle needs a bigger box then MS SQL Server (Hope you really meant this with SQL Server).
[ September 24, 2003: Message edited by: Oliver Refle ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic