Re: Web + Slicing/Paging datas

From: John R Pierce <pierce(at)hogranch(dot)com>
To: durumdara <durumdara(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Web + Slicing/Paging datas
Date: 2009-04-23 07:23:14
Message-ID: 49F01762.4090608@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seref Arikan 2009-04-23 08:44:53 Re: Help request to improve function performance
Previous Message durumdara 2009-04-23 07:09:39 Web + Slicing/Paging datas