RE: [PHP-DB] Output a few tupels of 493033 tupels
> 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Output a few tupels of 493033 tupels
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 __ Bequemer und billiger - SMS mit FreeMail verschicken! Mehr Information unter: http://freemail.web.de/features/?mc=021147 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php