Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: sbrattla (supportbrattland.no)
Date: Wed May 07 2008 - 09:41:46 CDT
My scenario is as described below, and i am in search of a better way to run
a query for that scenario. Any bright ideas are more than welcome!
I have a table <keyword> (which contains keyword_id, keyword_trackid,
keyword_title) and a table <track> (which contains track_id, track_title).
Obviously, i have a number of keywords describing each track.
I need to search for a keyword, and then get all tracks which this keyword
describes. However, i also need all other keywords which describes the found
tracks. I currently solve this with the following query:
SELECT K1.keyword_id, K1.keyword_trackid, K2.keyword_keyword FROM keyword K1
LEFT JOIN track T1 ON T1.track_id = K1.keyword_trackid
LEFT JOIN keyword K2 ON T1.track_id = K2.keyword_trackid
WHERE (K1.keyword_keyword LIKE '%<keyword>%')";
I am not really worried about full text search right now, as i am more
worried about that the query itself most likely will take ages when the
number of keywords gets bigger.
I could probably also do this with programming, but then again i would have
to get the list of all keywords from the database...which could be something
like 5 million keyword - track relations.
So, if you would happen to know how this query can be optimised, then i'd
very much appreciate that!
View this message in context: http://www.nabble.com/Any-better-ways-that-LEFT-JOIN--tp17106190p17106190.html
Sent from the MySQL - General mailing list archive at Nabble.com.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql