Try using SQL like that contained at http://weblogs.asp.net/scottgu/archive/2006/01/07/434787.aspx
You pass in the pageIndex and the numRows you want and let the sql get the right page of data for you. Paul. On 24/05/07, barry.beattie <[EMAIL PROTECTED]> wrote:
Jurgen please forgive me for asking, could you clarify what's going on at the .NET end and what the SWF would need to do to get the next "page" of data? would the 150k+ records be held in a dataset (or whatever) in memory (cache, session, etc) on the server? (flex would need to send a call back for next N records to cursor thru them, I assume). A handle to the cache would need to be sent too?
