Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Limiting Large Result Sets

Reply
Thread Tools

Limiting Large Result Sets

 
 
steve
Guest
Posts: n/a
 
      08-30-2006
On Wed, 30 Aug 2006 11:04:28 +0800, Arne Vajh°j wrote
(in article <Re7Jg.4462$_q4.3258@dukeread09>):

> Tom Cole wrote:
>> Oracle supports SQL LIMIT command:
>>
>> LIMIT <start_row>, <rows_to_return>

>
> Not my Oracle 9i.
>
> For many year rownum has been the answer.
>
> Arne



no it has not!!
READ the requirement.

rownum is for returning a MAXIMUM number of records related to a query.
normally for processing , it does not maintain any state or positional
information.

it is not for allowing a select of say 1,000,000 records and returning X
number at a time.

steve

 
Reply With Quote
 
 
 
 
=?ISO-8859-1?Q?Arne_Vajh=F8j?=
Guest
Posts: n/a
 
      08-31-2006
steve wrote:
> On Wed, 30 Aug 2006 11:04:28 +0800, Arne Vajh°j wrote
>> For many year rownum has been the answer.

>
> no it has not!!
> READ the requirement.
>
> rownum is for returning a MAXIMUM number of records related to a query.
> normally for processing , it does not maintain any state or positional
> information.
>
> it is not for allowing a select of say 1,000,000 records and returning X
> number at a time.


http://www.oracle.com/technology/ora...o56asktom.html

browse down to pagination.

Arne
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
6500: User-Based Rate Limiting AND Total Rate Limiting Patrick Cervicek Cisco 0 08-07-2007 03:07 PM
1. Ruby result: 101 seconds , 2. Java result:9.8 seconds, 3. Perl result:62 seconds Michael Tan Ruby 32 07-21-2005 03:23 PM
Looking for the best way to consolidate result sets into single responsemessage Edmond wong Java 0 04-14-2005 04:25 AM
Sql Server multiple XML result sets to ADO.NET randall g ASP .Net 1 12-29-2003 09:24 PM
Shaping data/multiple result sets - hmmm... Mike Kingscott ASP .Net 0 08-27-2003 12:39 PM



Advertisments