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.
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
