[TriLUG] MySQL Runaway

Brian McCullough bdmc at buadh-brath.com
Wed May 8 14:11:04 EDT 2013


On Wed, May 08, 2013 at 01:55:04PM -0400, Alan Sterger wrote:
> Brian,
> 
> A simple SELECT query containing a "Cartesian join" can bring any 
> database to it's knees.  A Cartesian join is the product of all Table A 
> rows and all Table B rows, within a join.  This condition can occur in 
> untested code or due to a novice developer.

Or even a "framework" that isn't too particular about its SQL.

Good reminder.  I have run into this kind of situation in at least one
other project.


Brian




More information about the TriLUG mailing list