Alessandro Baretta schrieb:
[EMAIL PROTECTED] wrote:
...
It looks like this is the only possible solution at present--and in the future, too--but it has a tremendouse performance impact on queries returning thousands of rows.
Well actually one of the better solutions would be persistent cursors (and therefore connection pooling). I bet this is easier then fiddling with the problems of offset/limit and inventing even more compex caching in the application. Just my 0.02c ++Tino ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly