[Ilugc] Re: PHP Pear DB
- From: lug@xxxxxxxxxxxxxxxxxx (Chandrashekar Babu)
- Date: Fri Sep 10 18:32:38 2004
Ankit Malhotra writes:
Hi all,
I would like to know if using PEAR DB conectivity in PHP would create
any issues regarding the speed of a web site interaction as the number
of connections increase.
PEAR DB is slow! If you want abstract database interface layer, you might
want to try ADODB (
http://phplens.com/lens/adodb/). Though, using any
database independent layer will cause performance drop down when compared to
access database using the DB specific API.
Also I have used MySQL and am now shifting to PostgreSQL. Would like
to know why it is not such a common platform with PHP. Guess speed is
1 factor. But after that i think PostgreSQL is more feature rich.
The last time I checked, the performance of PostgreSQL is very close to that
of MySQL. MySQL is supposed to be light-weight than PostgreSQL, which is
possibly one of the reasons why it was used as a backend for websites.
There's no reason for migrating to PostgreSQL unless you are using complex
features of SQL and you find MySQL too limiting, or you are looking for an
Object-Relational Data Model.
MySQL 4 with InnoDB support should be good enough for most website backend
database requirements. But then again, nothing stops you from moving to
PostgreSQL ;-)
Cheers,
Chandrashekar Babu.
Other related posts: