In general, is it more efficient to do many queries or one "large" query with many joins?
Good question. :)
I would break it down into smaller queries and use a loop because a large query, would consume a huge amount of memory and a join needs to create a temporary table so that would consume a large amount of disk space. If the queries are more than 5-10k rows, I would definitely break them into smaller queries. Doing a large join with hundreds of thousands of rows, or millions of rows, would put a strain on the server for both I/O and CPU that it would stop others from being able to access it.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]