SQL optimization: "multiple queries" vs. "big join"

[Eikinskjaldi]

Originally Posted by mihai11

I do have a "WHERE" clause, but that is not of much help. If there are no errors in the database then each story MUST have a corresponding thread. The only thing that will actually limit the number of returned rows is a "LIMIT clause".

No, that is not how queries work. They use where to optimise. the explain will clearly show you this.

I am using an index, but I do not agree with your conclusions.

They are not conclusions, they are facts. Use explain once or twice, and all will become clear.

mysqldump --opt --host=ABC-HOST -Q -uUSER -pPASSWORD db_name > db_file.sql

Ahh right, of course. I keep forgetting that works with innodb.