Hi,
The biggest drawback of PEAR DB is its interdependecies on multiple
classes from within PEAR. Aaprt from this, it has very good set of classes.
Anyway, you can also use PHPLib for database abstraction.
If working with MySQL, make sure you are not using persistant
connection. This slows down the system (MySQL).
PostgreSQL is a feature rich, heavy duty database. Its not suitable for
small applications where you just need SELECT, INSERT & DELETE.
HTH
Regards
Vinay
Ankit Malhotra wrote:
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. I am designing a small college database and
would at the maximum have 250 simultaneous connections (all the
students logging in to check there results.as the system will most
probably remain off line there will be a maximum of 250 local
connecions i presume. However depending upon the feedback may have to
put it on the main portal itself (which would be gr8) ). Would like to
keep the system open to usage of both PostgreSQL. and MySQL.( Also
would try to use something new :-)
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.