RE: Re[2]: [PHP] DB speed

Checkout osdb, it's the "Open Source Database Benchmark" it supports Postgres and MySQL and is available at http://osdb.sourceforge.net. To test Postgres and MySQL you will need both installed on the machine you try to compile from, you will need to compile with --with-mysql and --with-postgresql and you may need to specify the install points (i.e. ./configure --with-mysql=/usr/local --with-postgresql=/usr/local). I successfully compiled it on FreeBSD 4.6 but compile failed on HP-UX 11.11. Jason -----Original Message----- From: Uros Gruber [mailto:uros.gruber@sir-mag.com] Sent: Thursday, October 10, 2002 2:29 PM To: tuxen Cc: php-general@lists.php.net Subject: Re[2]: [PHP] DB speed Hi! I make some more test for this. When i enable pconect (persistant) the result amazed me. PGSQL Total time: 0.0070 Execution time: 0.0034 MySQL Total time: 0.0072 Execution time: 0.0027 Now PGSQL is as fast as mysql or maybe a littttttttle slower. So is this normal that non-persistant is so much overhead for pg. Is there any tools to check this. Or is some kind of a bug in php. I use 4.2.3. And pg is 7.2.1. Can somebody make some test. I can send script what i've run. -- tia, Uros mailto:uros.gruber@sir-mag.com Friday, October 11, 2002, 5:09:31 AM, you wrote: t> I think i read something a while ago, about mysql being faster, having t> less features, but postgres being a little slower but able to handle t> LARGE databases better than mysql. I could be wrong, so dont take my t> word for it. At the end of the day they are both good db's. t> On Thu, 2002-10-10 at 09:02, Simon Taylor wrote: >> 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 >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php