At 02:54 PM 1/20/2004, you wrote:
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]