many queries versus big joins

2004-01-20 Thread Stephen Fromm
In general, is it more efficient to do many queries or one large query with many joins? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: many queries versus big joins

2004-01-20 Thread mos
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