Re: DB speed

From my experience, I found this: Selecting 1000 records from 2 tables using a join, 10secs and up. Selecting 1000 records for table 1, all records from table 2, then using php to figure out which rows from table 2 belong to table 1 and building my own combined array, less than a second. > 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 > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >