DB class speed
| From: | Uros Gruber | Date: | Thu, 10 Oct 2002 12:14:14 +0000 |
| Subject: | DB class speed | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-2470@lists.php.net to get a copy of this message | ||
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
Time is in seconds.
My machine is PIII 333 MHz with 128MB RAM. I table is only 3
rows of data.
I want to know why is sucsh diference. Both servers runing
with socket connections and using connnect (non-persistant)
--
tia,
Uros mailto:uros.gruber@sir-mag.com