[转载] Help on getting large data from Oracle - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

[转载] Help on getting large data from Oracle

[转载] Help on getting large data from Oracle# Database - 数据库

f*y2004-07-11 07:07

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!

aw2004-07-11 07:07

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!