Uros Gruber [mailto:uros.gruber@[...].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

-- 
PEAR General Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php