Re: Standard Solutions with Perl DBI::Pg for results tables

1/ 10 each per page seems small, but maybe not if your retrieved row is large.

2/ cookies can be used to store AUTHENTICATION OF A USER, but since you are not doing that, cookies probably are not
whatyou want. 

3/ Form values originally used to search with can be used, and returned using:
    A/ Javascript filling in POST values and submitting, when a button is pressed
    B/ GET values on a URL on a button.
    C/ GET values on a URL on a text anchor

4/ to do 3 above, you will need either:
    A/ A cursor search in your original and second search.
    B/ A simulated cursor using the files system stored result set,
        in the manner of PHP library 'ADODB'. Perhaps
        Perl has such a library.


It comes down to two parts:

    A/ returning the same search criteria with a page begin and page size value
        in a form.
    B/ using native or simulated cursors to access the search

Mr Mat psql-mail wrote:
> I have users doing searches via a web front end.
>
> No authentication is required.
>
> I would like the result of the last search of each user to be stored in
> a temporary table to allow for re-ordering, searching within results,
> and stepping through results 10 (n) at a time using offset and limit.
>
> Currently I am preforming the search again for each of these - pretty
> annoying when it might take 10 minutes to return the results to begin
> with!
>
> Is there a standard way of doing this?
> I'd thought perhaps session id's and cookies?
>
> Can i specify a lifespan for a temporary table?
>
> Thanks!
>
> Matt
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>