摘要: In addition to update batching, Oracle JDBC drivers support the following extensionsthat improve performance by reducing round-trips to the database:■Prefetching rowsThis reduces round-trips to the database by fetching multiple rows of data eachtime data is fetched. The extra data is stored in clien 阅读全文
posted @ 2011-08-29 17:15 freewater 阅读(323) 评论(0) 推荐(0) 编辑
摘要: Note:■Oracle recommends that you use JDBC standard features whenpossible. This recommendation applies to update batching as well.Oracle update batching is retained primarily for backwardscompatibility.■For both standard update batching and Oracle update batching,Oracle recommends you to keep the bat 阅读全文
posted @ 2011-08-29 16:53 freewater 阅读(1411) 评论(0) 推荐(0) 编辑
摘要: Statement caching improves performance by caching executable statements that areused repeatedly, such as in a loop or in a method that is called repeatedly. Startingfrom JDBC 3.0, JDBC standards define a statement-caching interface.Statement caching can do the following:■ Prevent the overhead of rep 阅读全文
posted @ 2011-08-29 14:25 freewater 阅读(722) 评论(0) 推荐(0) 编辑