PDA

View Full Version : RE: Patch for the SQL branch



2004-08-18, 23:38
Erm... (trying hard not to start a "mine's better than yours" type war...)
Yes it does; and Yes it does!

Subqueries: http://dev.mysql.com/doc/mysql/en/ANSI_diff_Subqueries.html

Transactions:
http://dev.mysql.com/doc/mysql/en/InnoDB_transaction_isolation.html


Although I've most seen Subqueries used to create sloppy queries where an
optimised join can be a better solution (case-by-case basis). They can be
great when used correctly, but bad when sloppily used,

Jools
(Qualified Oracle DBA, MySQL and MS SQL Server admin/user)

-----Original Message-----
From: developers-bounces (AT) lists (DOT) slimdevices.com
[mailto:developers-bounces (AT) lists (DOT) slimdevices.com] On Behalf Of Michael
Brouwer
Sent: 19 August 2004 00:28
To: Slim Devices Developers
Subject: Re: [Developers] Patch for the SQL branch


Not to start a my db is better than yours flamewar or anything, but
MySQL doesn't support transactions either so I really wouldn't consider
it for any serious data anyway.

Michael

On Aug 18, 2004, at 2:07 PM, Will McDonald wrote:

> On Mon, Aug 16, 2004 at 07:31:27AM -0600, bill wrote:
>> In my experience (mostly Oracle, some Informix, Illustra and SQL
>> Server), multi table joins can be optimized by using in-line views
>> (sub selects).
>
> MySQL doesn't (yet) support sub-selects, and it's the most popular
> free RDBMS. Something to keep in mind...
>
> --
> ---------Will McDonald-----------------will (AT) upl (DOT) cs.wisc.edu----------
> GPG encrypted mail preferred. Join the web-o-trust! Key ID: F4332B28
>
>

Will McDonald
2004-08-19, 07:51
On Thu, Aug 19, 2004 at 07:38:26AM +0100, julians (AT) nr-online (DOT) com wrote:
> Erm... (trying hard not to start a "mine's better than yours" type war...)
> Yes it does; and Yes it does!
>
> Subqueries: http://dev.mysql.com/doc/mysql/en/ANSI_diff_Subqueries.html

MySQL 4.1 does, but that's still beta. This is all sort of academic because
only hackers will be using their own DB, and they very well may be fine with
installing 4.1, but most people are still using 4.0, so I wouldn't count on
subqueries. Though again, it should't matter a whole lot to Slim Devices.

FYI, I found this to be a useful page comparing RDBMSs:
http://dev.mysql.com/tech-resources/crash-me.php

--
---------Will McDonald-----------------will (AT) upl (DOT) cs.wisc.edu----------
GPG encrypted mail preferred. Join the web-o-trust! Key ID: F4332B28