Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Performance and driver type  RSS feed

 
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!