Re: paging results in large resultsets: mysql vs postgresql?
| From: | Richard Lynch | Date: | Thu, 15 Jun 2006 21:41:27 +0000 |
| Subject: | Re: paging results in large resultsets: mysql vs postgresql? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-238115@lists.php.net to get a copy of this message | ||
On Thu, June 15, 2006 11:11 am, D. Dante Lorenso wrote:
> I just discovered this neat little gem in MySQL which makes it easy to
> page large result sets:
>
> * SELECT SQL_CALC_FOUND_ROWS *
>
> * SELECT FOUND_ROWS()
>
> I can't seem to find the equivalent of it in PostgreSQL! The only
> options I see are:
>
> 2.
>
> Using PHP row seek and only selecting the number of rows I need.
3. use the built-in "cursor" of PostgreSQL which pre-dates MySQL
LIMIT and OFFSET clauses, which are non-standard hacks Rasmus
introduced back in the day.
--
Like Music?
http://l-i-e.com/artists.htm