hey, can i hijack my message back?...this thread is about the performance of
subselects, not stored procedures. go write your own message :-)...
sothe original question is if someone would be nice enough to answer..
Do any MySql coders writing subselects in 4.1 know whether EXISTS will
Message-
From: Greg Matthews [mailto:greg55;ozemail.com.au]
Sent: Monday, November 11, 2002 7:38 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: MySql 4.1 Sub Selects and not stored procedures
hey, can i hijack my message back?...this thread is about the performance of
subselects, not stored procedures
In the last episode (Nov 11), Greg Matthews said:
hey, can i hijack my message back?...this thread is about the performance of
subselects, not stored procedures. go write your own message :-)...
sothe original question is if someone would be nice enough to answer..
Do any MySql
: Tuesday, November 12, 2002 12:02 AM
Subject: RE: RE: MySql 4.1 Sub Selects and not stored procedures
I'm not sure where you're getting your information (Typically, db vendors
recommend you use an exists clause, not a join when testing for the
presence
of child data because it's faster
the EXISTS logic is ugly in as sql statement.
does that count? seems like ugly should count.
hey, can i hijack my message back?...this thread is about the performance of
subselects, not stored procedures. go write your own message :-)...
sothe original question is if someone would