由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - [转载] Help on getting large data from Oracle
相关主题
[转载] JDBC用完了oracle的large pool (memory),怎么办?谁来介绍一个VERY LARGE OLTP配置啊
oracle 10g certificatecompare two large tables SQL (转载)
sql questionSQL find distinct values in large table
mysql maximum columns <=1000?换件马甲爬上来
why did this sql statement always fail in oracle?Re: Web Database
Oracle8概 述从Technet那里拿的Oracle光盘版本有什么限制?
求职Oracle DBA请教oracle8如何用
Re: 学Java的不要老想着考证 (转载)oracle和XML
相关话题的讨论汇总
话题: oracle话题: data话题: large话题: getting话题: million
进入Database版参与讨论
1 (共1页)
f*******y
发帖数: 348
1
【 以下文字转载自 Java 讨论区,原文如下 】
发信人: frostlily (小熊嘟嘟), 信区: Java
标 题: Help on getting large data from Oracle
发信站: Unknown Space - 未名空间 (Sun Jul 11 12:21:59 2004) WWW-POST
I want to read a very large data set(over 1 Million records) out from Oracle
database. if I use resultset.next(), I will need at least 6 min just loop
through it. Anyone knows any trick that I can get the whole data within 30
sec? or within 1 min?
Thank you very much!
aw
发帖数: 127
2
it has nothing to do with oracle, your code design sounds horrible, 1 million
records? check with your tech lead/project manager before you do it.

【在 f*******y 的大作中提到】
: 【 以下文字转载自 Java 讨论区,原文如下 】
: 发信人: frostlily (小熊嘟嘟), 信区: Java
: 标 题: Help on getting large data from Oracle
: 发信站: Unknown Space - 未名空间 (Sun Jul 11 12:21:59 2004) WWW-POST
: I want to read a very large data set(over 1 Million records) out from Oracle
: database. if I use resultset.next(), I will need at least 6 min just loop
: through it. Anyone knows any trick that I can get the whole data within 30
: sec? or within 1 min?
: Thank you very much!

1 (共1页)
进入Database版参与讨论
相关主题
oracle和XMLwhy did this sql statement always fail in oracle?
[转载] what's the equivalent of 'minus' (oracle) in access?Oracle8概 述
Oracle 8i for Linux求职Oracle DBA
Oracle Lite 4.0 on 95Re: 学Java的不要老想着考证 (转载)
[转载] JDBC用完了oracle的large pool (memory),怎么办?谁来介绍一个VERY LARGE OLTP配置啊
oracle 10g certificatecompare two large tables SQL (转载)
sql questionSQL find distinct values in large table
mysql maximum columns <=1000?换件马甲爬上来
相关话题的讨论汇总
话题: oracle话题: data话题: large话题: getting话题: million