Re: retrieving data from the table in chunks for paging

Then do it in middleware. Keep your own context using the cookie. But you are right, it's not a generalized solution, but, as you say, the OP didn't provide front-end info. Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Mar 27, 2009 at 7:47 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > On Mar 27, 4:59 pm, Art Kagel <art.ka...@gmail.com> wrote: > > You don't mention what you are using for a front-end, but in most of them > > including ESQL/C, 4GL, ODBC, JDBC, and others, you can take advantage of > > IDS's SCROLL CURSOR feature: > > > Since she didn't say what application or front end tools, I don't know > that it would be a good idea to use a scroll cursor. > If they're using a web interface, you're kind of screwed. You have to > maintain state and you can't pool your connection threads if you use a > scroll cursor. > (The cursor has to remain active until the session times out so when > you dynamically create the cursor, you'd have append the session_id to > the cursor name. It can be done, but its ugly and kind of violates > some of the design patterns.) > > This would mean that you'd have to design a pk for the table and then > track the last row retrieved and get the next set of rows. Even this > has some issues in a web app... > > But I do agree, if you're doing straight client/server with 4GL and or > Java, yeah you can use a scroll cursor. > > HTH > > -G > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >