Re: bookmarks and keywords

Baron Schwartz schrieb:

>> SELECT
>> child.bookmark_id,
>> child.bookmark_title,
>> child.bookmark_url
>> FROM
>> bookmarks AS child
>> WHERE
>> child.bookmark_keyword IN (
>> SELECT
>> parent.bookmark_keyword
>> FROM
>> bookmarks AS parent
>> WHERE
>> parent.bookmark_url = 'http://www.redhat.com'
>> )

> 
> I would STRONGLY recommend AGAINST using subqueries in this manner.
> MySQL optimizes this type of subquery very poorly, and I wouldn't even
> "test" this query if the table is large -- it may kill the server.  A
> JOIN is the right approach here.

i don't think so

-- 
Sebastian



-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com