On 10/16/06, Alban Hertroys <alban@xxxxxxxxxxxxxxxxx> wrote:
Merlin Moncure wrote: > for server side browsing use cursors or a hybrid pl/pgqsl loop. for > client side, browse fetching relative to the last key: > > select * from foo where p > p1 order by p limit k; This does require some way for the client to keep a single transaction open. If this kind of query is performed by a web application (as is often the case), the "client" is the server side web script engine, and not all of those beasts are capable of keeping a transaction open across pages (PHP comes to mind). This combined with expensive (complex) queries is regularly a pain.
Server-side browsing requires transactions so is unsuitable for certain types of web enviroments. However client-side following as I described as not...it is the right and proper way to solve this problem . It's also why the sql row-wise comparion is so important, because it provides an easy way to do this with table with mutiple part keys. merlin
