Andrei Bintintan wrote:
If you're using this to provide "pages" of results, could you use a cursor?

What do you mean by that? Cursor?

Yes I'm using this to provide "pages", but If I jump to the last pages it goes very slow.

DECLARE mycursor CURSOR FOR SELECT * FROM ... FETCH FORWARD 10 IN mycursor; CLOSE mycursor;

Repeated FETCHes would let you step through your results. That won't work if you have a web-app making repeated connections.

If you've got a web-application then you'll probably want to insert the results into a cache table for later use.

  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: 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

Reply via email to