On Wednesday 06 February 2002 12:29, Alok K. Dhir wrote: > The way I look at it, MySQL gives you a choice of table types, so you > can pick the one best suited to the task at hand. For raw speed where > you can do without transactions, you can go with MyISAM. Otherwise you > have Innobase. I'm not sure where/why db3 fits in, haven't been > bothered to look into it yet.
I have to agree, I like having the choice, I have some applications that I feel would be hurt by the overhead of transactions. I have other applications that were more difficult to develop without transactions. Now I can have my cake and eat it too. Choice, one of the main reasons I switched to Linux, and now, one of the main reasons I'm happy I chose MySQL in the first place! John > On the other points, you are correct. Can't wait for subselects... > > > -----Original Message----- > > From: [EMAIL PROTECTED]=20 > > [mailto:[EMAIL PROTECTED]] On Behalf Of Trond=20 > > Eivind Glomsr=F8d > > Sent: Wednesday, February 06, 2002 12:10 PM > > To: Sinisa Milivojevic > > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: Re: PostgreSQL > >=20 > >=20 > > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > >=20 > > > > > Trond Eivind Glomsr=F8d writes: > > > > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > >=20 > > > > > > > > > Anyone know the difference between MySQL and PostgreSQL? > > > > > > > >=20 > > > > PostgreSQL has a lot of features MySQL don't have yet=20 > > > > (transactions=20 > > > > > > everywhere, foreign keys, subselects, stored procedures,=20 > > > > triggers,=20 > > > > > > etc), while MySQL is heavily optimized for handling big loads of=20 > > > > simple SQL. > > > > > >=20 > > > But MySQL has transactions and foreign keys. > > > >=20 > > I said "everywhere" - you need to use Innobase to get foreign=20 > > keys, and=20 > > innobase/db3 to get transactions. > >=20 > > --=20 > > Trond Eivind Glomsr=F8d > > Red Hat, Inc. > >=20 > >=20 > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > >=20 > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail=20 > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >=20 > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php