AW: [PEAR] DB class speed

Uros Gruber [mailto:uros.gruber@sir-mag.com] wrote: > > Hi! > > I'm making some testing over DB.php > > And i wan't to know if this is normal. > > I've made some script where I connect do SQL server > and execute one simple (1row) query. > > I use pgsql and mysql. tables and indexes are same for both > servers. So test table is identical > > Whe i execute those script i get some timing results > > PGSQL > Total time: 0.0576 > Execution time: 0.0185 > > MySQL > Total time: 0.0086 > Execution time: 0.0028 > > I want to know why is sucsh diference. Both servers runing > with socket connections and using connnect (non-persistant) I think the non-persistent DB connection is the cause of the difference. Maybe pgsql connects take (that) much longer than mysql's ? I think you should try to a) benchmark only the queries and row retrieval (and/or get an extra bench for connection creation) b) do an application-level benchmark, that is with some real data and production logic Btw, are there some benches for DB vs PHP's builtin clients (MySQL, Postgres, Informix), perhaps with PHP-Acellerator? Thomas