Does Oracle support returning a subset of a result set? for example, from record 50 - 100.
That would solve memory issues.
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] 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:[EMAIL PROTECTED]
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
