myfaces-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Haynes <david.hayn...@sympatico.ca>
Subject Re: dataTable - Millions of records
Date Sat, 10 Sep 2005 11:01:16 GMT
Yes.
For Oracle, the select would be like this: (example from Troels Arvin)

| SELECT * FROM (
  SELECT
    ROW_NUMBER() OVER (ORDER BY key *ASC*) AS rn,
    columns
  FROM tablename
)
WHERE rn > skip AND rn <= (n+skip)

Troels has a really useful comparison/how-to page at 
http://troels.arvin.dk/db/rdbms/#legend
|Dave wrote:

> Does Oracle support returning a subset of a result set? for example, 
> from record 50 - 100.
> That would solve memory issues.
>
> */gvial@C3tools.com/* wrote:
>
>     I totally see the purpose of coding the SQL so that you would get
>     only a subset of the data at a time (Oracle gives what you pointed
>     out. SQL Server, as far as i know does not offer such
>     functionality out of the box) . However, once you throw sorting
>     data in the game, isn't it much more complicated to handle and
>     might actually make you run more queries than required if you deal
>     with the subset/ordering in your backing bean?
>      
>     I'm not actually sure here, I'm just wondering how you would
>     handle sorting and using subsets in that case... It's an
>     interesting dicussion though as many people are either going
>     through this, or will go through it when developping their
>     applications.
>      
>     Greg
>
>         -----Original Message-----
>         *From:* David Haynes [mailto:david.haynes2@sympatico.ca]
>         *Sent:* Fri 9/9/2005 8:32 PM
>         *To:* MyFaces Discussion
>         *Cc:*
>         *Subject:* Re: dataTable - Millions of records
>
>          
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>



Mime
View raw message