RE: [PHP-DB] Output a few tupels of 493033 tupels
| From: | Rich Gray | Date: | Tue, 11 Mar 2003 15:11:04 +0000 |
| Subject: | RE: [PHP-DB] Output a few tupels of 493033 tupels | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26251@lists.php.net to get a copy of this message | ||
> Hello,
>
> I have got a little problem with my datas. In one table I have
> got 493033 tupels. A simple Output of all datas is to much for
> the Browsers (and the intranet-connection) and to ask for all and
> then only give out a few is also a big problem for the server.
>
> Is there any way only to ask for some tupels in a
> postgres-database with PHP?
>
> H. Etzel
IIRC Postgres supports the limit and offset options on a select statements
so how about - for 100 rows starting at the first row...
select * from mytable limit 100, 0
Rich