pp wrote: > > SELECT article.id FROM article LEFT JOIN repligard ON article.id = > > repligard.id WHERE repligard.id is NULL; > > > > do if you run it by hand? > > almost hang my box. no output . nothing , and 90% CPU usage. > > and after 15-20 minutes ends with success :)
Ehm... I think that's a MySQL bug. They almost literally recommend this query in their docs: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Emile --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
