ORACLEthinoci对比Oracle认证考试

文章作者 100test 发表时间 2010:04:10 19:35:14
来源 100Test.Com百考试题网

　　又遇oracle的thin和oci问题，这个问题困扰了很久，到底有什么区别呢，查了很多资料终于有些眉目了，还是官方的资料好啊。（不知道 oci和thin的请看我之前的一个转帖）

　　首先第一个问题OCI 和 THIN 谁快，

　　这个官方有说，同时也有非官方的人做过测试。来看下结论。

　　Thin Driver

　　Can the Thin JDBC Driver be used to develop Java applications?

　　Yes, the thin JDBC Driver can be used to develop both Java applets and Java applications. Since it is written completely in Java it is downloadable and therefore can be used with Java applets. It can also be used for Java applications but only if you are using TCP/IP. Unlike the JDBC OCI driver, the Thin JDBC driver only works with TCP/IP-based networks. Users who are running applications on non-TCP/IP networks are encouraged to use the JDBC OCI driver.

　　Performance

　　Which is faster, the Thin driver or the OCI driver?

　　As always, it depends. There are some applications where the the Thin driver is faster, some where the OCI driver is faster. As of 10.1.0, the Thin driver is probably slightly faster than the OCI driver. In cases when the client and server are the same type of hardware and OS, the OCI driver puts a little less load on the RDBMS, even though the Thin client is faster. The differences are usually small, less than 10%. Most of our customers use the Thin driver because of its easier administration. Your mileage may vary.