注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

lazydba

hello

 
 
 

日志

 
 

甲骨文JDBC Performance Extensions  

2007-07-05 19:47:39|  分类: all about databa |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

Oracle Database JDBC Developer's Guide and Reference, 10g Release 2 (10.2)
B14355-02
Copyright ? 1999, 2006,?Oracle. All rights reserved.
Primary Author: ?Venkatasubramaniam Iyer, Elizabeth Hanes Perry, Brian Wright, Thomas Pfaeffle
Contributing Author: ?Brian Martin

25 Performance Extensions

Update Batching
Setting the Connection Batch Value
((OracleConnection)conn).setDefaultExecuteBatch(20);
?
Setting the Statement Batch Value
((OraclePreparedStatement)ps).setExecuteBatch(2);
?
((OraclePreparedStatement)ps).getExecuteBatch());
?
Checking the Batch Value
Integer batch_val = ((OracleConnection)conn).getDefaultExecuteBatch();
Integer batch_val = ((OraclePreparedStatement)ps).getExecuteBatch();
?
Committing the Changes in Oracle Batching
Update Counts in Oracle Batching
?
Additional Oracle Performance Extensions

In addition to update batching, Oracle JDBC drivers support the following extensions that improve performance by reducing round trips to the database:

  • Prefetching rows

    This reduces round trips to the database by fetching multiple rows of data each time data is fetched. The extra data is stored in client-side buffers for later access by the client. The number of rows to prefetch can be set as desired.

  • Specifying column types

    This avoids an inefficiency in the normal JDBC protocol for performing and returning the results of queries.

  • Suppressing database metadata de<TABLE_REMARKSde< columns

    This avoids an expensive outer join operation

整篇文章没有一句话是自己写的, Shy


  评论这张
 
阅读(133)| 评论(3)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017