Monday, August 16, 2004

Molasses in January

I'm no expert on the guts of databases, but as far as I can tell there is no reason on God's green earth that this

insert into soccerstats
from soccerstatsold s 
left join games on (
(s.game_id = games.old_id) and 
('7' or'14'))

should be taking over eight minutes to run. It's maddening! Think I need to get a copy of this.

No comments: