Re: Web + Slicing/Paging datas - Mailing list pgsql-general

From John R Pierce
Subject Re: Web + Slicing/Paging datas
Date
Msg-id 49F01762.4090608@hogranch.com
Whole thread Raw
In response to Web + Slicing/Paging datas  (durumdara <durumdara@gmail.com>)
Responses Re: Web + Slicing/Paging datas
List pgsql-general
durumdara wrote:
> Hi!
>
> In a mod_py application I wanna write a wrapper that handle all PSQL
> data view with paging/slicing.
>
> ..
> Inserts all records to a temp table.
> Check the affected rows (as count).
> Slicing the records.
> Fetch the slice records.
> Destroy temp table.


how about KEEPING the data in this slice format, and keeping the count
somewhere ?  you'd need to update the count and slice info when new data
gets added, but perhaps thats better than doing it every time you want
to view a slice?



pgsql-general by date:

Previous
From: durumdara
Date:
Subject: Web + Slicing/Paging datas
Next
From: Seref Arikan
Date:
Subject: Re: Help request to improve function performance