RE: [PHP] DB speed

Would access be a lot slower than these then for a query with multiple tables and other such things? Is there a resource on the net regarding this? -----Original Message----- From: Dan Ostrowski [mailto:news-client@triad-dev.com] Sent: 10 October 2002 18:43 To: tuxen Cc: php-general@lists.php.net Subject: Re: [PHP] DB speed For SIMPLE SIMPLE selects and inserts, MySQL will probably remain faster. If you are doing a very simple web set up where you are mostly inserting and spitting out single table information, MySQL will be the way to go. Anything else, I would recommend PostgreSQL. It's got FAR superior features and anytime you start very complex queries ( like JOINS and multi-table aggregate functions, etc ) postgres will blow MySQL out of the water. They are both nice, just for different purposes. MySQL = simple, PostgreSQL = anything else. Also, you can run "EXPLAIN <query>" on PostgreSQL to find out exactly what is happening when you do a query and if it's using an index properly or not. regards, dan tuxen wrote: >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 >> >> >> >> >> > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php