| Author |
how to read few records at a time?
|
yamini nadella
Ranch Hand
Joined: Apr 13, 2004
Posts: 257
|
|
|
I have 100,000 records. I dont want to get all records in to resultset at a time. So what procedure I have to follow. Is execute qury returns all records at a time to resultset object?
|
 |
Shailesh Chandra
Ranch Hand
Joined: Aug 13, 2004
Posts: 1076
|
|
|
use where clause in your select query
|
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
|
|
Srinivasa Raghavan
Ranch Hand
Joined: Sep 28, 2004
Posts: 1228
|
|
|
A pattern like Value list handler might help you.
|
Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
|
|
kri shan
Ranch Hand
Joined: Apr 08, 2004
Posts: 1300
|
|
|
Try CachedRowSet
|
|
Kash Mhai
Greenhorn
Joined: Apr 01, 2005
Posts: 29
|
|
|
Try sorting the query and use of TOP and appropriate where on primary key to get as many records as needed.
|
-------------<br />There are wheels within wheels...<br />P.G Wodehouse
|
|
kri shan
Ranch Hand
Joined: Apr 08, 2004
Posts: 1300
|
|
|
What is TOP ??
|
|
Shailesh Chandra
Ranch Hand
Joined: Aug 13, 2004
Posts: 1076
|
|
TOP is used in sql server like
SELECT TOP (5) * FROM MyTable
Shailesh
|
|
 |
|
|
subject: how to read few records at a time?
|
|
|
0
