Re: PHP development with PostgreSQL
| From: | Miles Thompson | Date: | Fri, 24 Aug 2001 12:43:54 +0000 |
| Subject: | Re: PHP development with PostgreSQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11785@lists.php.net to get a copy of this message | ||
Lester,
Are you querying on indexed fields? That's the key to speed; check the MySQL docs on how it uses indexes. 20k records is not a large database.
Miles
At 04:06 PM 8/24/01 +0800, Lester June Cabrera wrote:
Hi, We've been using MySQL for 2 years now in all the PHP systems we have developed for our clients. We're thinking of using PostgreSQL now. What is your experience with PostgreSQL? Any comments? The reason why we want to shift is because we have encountered some problems with one of our databases whose table contains more than 20K records. Somehow, it took so long to query the database. Is PosgtreSQL a good substitute? We're expecting a million records for our new project. Thanks, Lester -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net