Search Postgresql Archives

Re: Web + Slicing/Paging datas

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux