This content has been marked as final.
Show 1 reply
-
1. Re: Performance problem with LEFT JOIN
proudchief May 14, 2007 10:42 AM (in response to toni)I don't see a join clause in your query. Without a join clause, you will get a cartesian product, and the performance will degrade exponentially as the tables grow.
You need something like "Template.id = message.id" to avoid a cartesian product.
You can see examples of what I'm talking about here:
http://www.w3schools.com/sql/sql_join.asp