(no subject)
Jun. 1st, 2005 10:47 pmthe worst part about doing something *this* stupid is doing it again, two days later...
Update: no, this was stupider. not only did i remove the join from the where clause, i removed the main id condition with it, so instead of getting 1 row, or even 1 * 65,000 rows (the amount in the second table), it was getting 1 * 65,000 * 112,000 rows.
Needless to say, the Java JBoss server didn't like that.
Update: no, this was stupider. not only did i remove the join from the where clause, i removed the main id condition with it, so instead of getting 1 row, or even 1 * 65,000 rows (the amount in the second table), it was getting 1 * 65,000 * 112,000 rows.
Needless to say, the Java JBoss server didn't like that.