The Resource For PHP Developers

php3-list | 199903

[PHP3] [OT]: SELECT COUNT(*) in Postgres From: Jordan Krushen (jordan <email protected>)
Date: 03/31/99

Next message: Steve Edberg: "Re: [PHP3] i can not use MAIL() function in WIN95!!!!!!"
Previous message: Clark Evans: "[PHP3] xmllib"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I know that MySQL doesn't actually hit the tables when doing a SELECT
COUNT(*), and it returns very quickly as a result.. On large Postgres
tables, COUNT(*) is horrendously slow. What I'm wondering is if anybody
here knows a faster way to get the row count, be it an internal Postgres
variable one can access, or if a COUNT(small_primary_key) would be faster.
Any ideas?

Thanks,

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>

Next message: Steve Edberg: "Re: [PHP3] i can not use MAIL() function in WIN95!!!!!!"
Previous message: Clark Evans: "[PHP3] xmllib"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Find a programming school near you

php3-list | 199903