[Twisted-web] my first post,
writing a Web interface to a PostgreSQL db
L. Daniel Burr
ldanielburr at mac.com
Fri Oct 14 10:50:27 MDT 2005
My apologies, I didn't understand that you wanted to cache the entire
dataset at the beginning.
In that case, I'd select the data into a temporary table ( a temp table
containing only 1000 records should be very fast to access, once it is
populated) at startup time, and them use the LIMIT OFFSET strategy against
the temporary table.
Does this meet your need a little better?
L. Daniel Burr
On Fri, 14 Oct 2005 08:33:18 -0500, Michele Simionato
<michele.simionato at gmail.com> wrote:
> On 10/14/05, L. Daniel Burr <ldanielburr at mac.com> wrote:
>> This is very simple to do, using the LIMIT OFFSET functionality in
>> Postgres.
>
> No, doing a full select or a select with OFFSET takes the same amount of
> time,
> the query is restarted from the beginning.
>
> _______________________________________________
> Twisted-web mailing list
> Twisted-web at twistedmatrix.com
> http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-web
More information about the Twisted-web
mailing list