Newbie: is this Query Reasonably Efficient ?

[Graham Anderson]

I have 3 different tables I need data from....
And, the tables have the potential to get  fairly large
I am using mysql 4.1.3
This working query below pulls up all media requests  for 'Yolanda 
Perez' in Los Angeles
Is there a appreciably  speedier way to say the below ?
I have begun dipping my toe into more complicated queries

Select artist.name,media.name,userLog.city,userLog.DateTime
From userLog,media,artist
Where city = 'Los Angeles' And
userLog.media_id = media.id And
media.artist_id=artist.id And
artist.name = 'Yolanda Perez'

many thanks
g
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]