RE: [PHP] DB speed

Well obviously - cos MySQL rocks!!, but seriously I also did some tests and got variable results from different db's - even got an odbc connection to access to run faster than mysql at one stage!! - something tells me there are other factors contributing.. Cheers Simon -----Original Message----- From: Uros Gruber [mailto:uros.gruber@sir-mag.com] Sent: 10 October 2002 14:17 To: php-general@lists.php.net Subject: [PHP] DB speed Hi! I'm making some testing over DB.php (PEAR) 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php