RE: speed optimization on awkward self join

2002-05-04 Thread Roger Baklund
* Colin Anderson [...] > SELECT a.name, b.value, bb.value > FROM characters a, char_data b, char_data bb, char_data_type c, > char_data_type cc > WHERE a.id = b.character_id > and a.id = bb.character_id > and (b.char_data_type_id = c.id > and b.value = '18' > and c.type = 'Strength') >

speed optimization on awkward self join

2002-05-03 Thread Colin Anderson
I'm starting to get pretty comfortable with mysql, but I'm still a beginner, and I've run into a problem I can't seem to get around. I'm having trouble getting a particular query to run within anything approaching a reasonable amount of time -- I'm not sure whether it's a problem with my query s