Redian新闻
>
Re: how to improve the performance of Oracle Insert operation?
avatar
Re: how to improve the performance of Oracle Insert operation?# Database - 数据库
q*e
1
According to my experience in DB2 and Informix, batch insert
commit(usually about thousands of record) is faster than
single record or less than one hundred record commit. I
think in Oracle it should work too. Also, in oracle, there
should have some parameters to be adjusted for performance.
You can ask some oracle experts.
avatar
h*r
2
Thanks a lot.

【在 q***e 的大作中提到】
: According to my experience in DB2 and Informix, batch insert
: commit(usually about thousands of record) is faster than
: single record or less than one hundred record commit. I
: think in Oracle it should work too. Also, in oracle, there
: should have some parameters to be adjusted for performance.
: You can ask some oracle experts.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。