Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Performance and driver type

 
Jun Hong
Ranch Hand
Posts: 181
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys,
I have a general question. We have four types of JDBC drivers. Normally, which one has better performance? I looked at the document from Oracle, they said OCI is faster than thin, but I did not find OCI faster. Theoretically, type II use bineray library and it should be faster than type IV however I heard people say type IV is the fastest.
Jun Hong
[ January 04, 2002: Message edited by: Jun Hong ]
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That's a good question. I remember reading something like that before, but I can't really remember the details.
Why don't you try it yourself? For a fact, the Oracle thin driver is a little bit faster than the OCI driver.
 
Jun Hong
Ranch Hand
Posts: 181
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Stanley,
Thank you for your reply. I think right now we can use JIT or HotSpot JVM, and this makes thin driver faster. On IBM HotSpot JDK 1.3, I also find thin driver a little bit faster. Perhaps, in old days (before JIT) OCI was faster. Type I is slow and we all know that. Did someone try Type III?
Jun Hong
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, in general, Type IV drivers are the fastest because there is the least amount of layers to get to the database.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic