RE: [PHP] About Commit..

postgres outperforms mysql on very high traffic sites where there are lots of INSERT and UPDATE commands issued, but for small sites where a majority of database calls are reading (SELECT), MySQL kicks postgres ass... there was a really good article on phpbuilder.com a few months back... check it out. > -----Original Message----- > From: Chris Lee [mailto:lee@mediawaveonline.com] > Subject: Re: [PHP] About Commit.. > > > mysql does support transactions if used with berkely db. php does not > support mysql transactions. in any sort of functions sence, you can try > passing the commands to mysql with the mysql_db_query() command, but do not > if this will work. if your looking for a completely new database, try > postgres, its very nice, more feature rich and comparable to speed to mysql.