RE: dataTable - Millions of records

[gvial]

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