Richard Lynch wrote:
On Fri, October 20, 2006 10:04 am, Fourat Zouari wrote:
I have PHP/PostgreSQL application were i got a search page with some
items
to search, am building the search query on server side.
I need to display a paginated search and for this i need to get the
total
count of lines matching the search before OFFSET/LIMITing my page, am
i
obliged to repeat the query twice ??? first to get the total count,
second
to get my page.
it's very heavy
Any one's suggesting better doing ?
Use a cursor.
Cursors won't help - they don't store the info about how many results
the query would fetch (I asked this question a few months ago on one of
the postgres lists).
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
