RE: [PHP] DB speed

I think i read something a while ago, about mysql being faster, having less features, but postgres being a little slower but able to handle LARGE databases better than mysql. I could be wrong, so dont take my word for it. At the end of the day they are both good db's. 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 > > >