RE: [PEAR] RE: [PEAR-DEV] numRows(), out of order row fetching and stuff?
| From: | Lukas Smith | Date: | Mon, 21 Jul 2003 13:49:09 +0000 |
| Subject: | RE: [PEAR] RE: [PEAR-DEV] numRows(), out of order row fetching and stuff? | ||
| References: | 1 | Groups: | php.pear.dev php.pear.general |
| Request: | Send a blank email to pear-dev+get-18488@lists.php.net to get a copy of this message | ||
> From: Hans Lellelid [mailto:hans@appliedsec.com]
> Sent: Monday, July 21, 2003 3:39 PM
>
> | Is it ok to drop numRows()?
>
> In the apps that I've written with MDB, I don't think I've ever needed
to
> use numRows(). I was going to say that numRows() is important when
doing
> pagination, but even in that case, my "Search" classes just rebuild a
> COUNT(*) version of the query to use for calculating total result set
> length.
Yeah if all you are concerned with is the number of rows then use
COUNT(*).
> Do most drivers support seek() ? Seems like they do -- e.g.
> mysql_data_seek(), mssql_data_seek(), pg_result_seek() -- but maybe
that's
> only for buffered queries?
Oracle doesnt for example.
Regards,
Lukas