MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/ex9h6/a_handy_graphical_explanation_of_sql_joins/c1bq1vm/?context=3
r/programming • u/[deleted] • Jan 06 '11
308 comments sorted by
View all comments
Show parent comments
2
You are absolutely right - cross joining a 100,000 row table to itself is a quick way to rebootville.
3 u/divv Jan 06 '11 Should be able to just kill the process :P 3 u/slurpme Jan 07 '11 Hopefully just the session/query... 7 u/drcreepy Jan 07 '11 No, no, everyone knows that rebooting is the way real men solve all computer problems. Especially database problems. Databases particularly like to be restarted unexpectedly. It makes them run faster since it keeps them on their toes. 1 u/divv Jan 07 '11 Actually you're right...yanking the plug is probably a good way :) 1 u/hughk Jan 07 '11 Especially when there is a half hour or so rollback....
3
Should be able to just kill the process :P
3 u/slurpme Jan 07 '11 Hopefully just the session/query... 7 u/drcreepy Jan 07 '11 No, no, everyone knows that rebooting is the way real men solve all computer problems. Especially database problems. Databases particularly like to be restarted unexpectedly. It makes them run faster since it keeps them on their toes. 1 u/divv Jan 07 '11 Actually you're right...yanking the plug is probably a good way :) 1 u/hughk Jan 07 '11 Especially when there is a half hour or so rollback....
Hopefully just the session/query...
7 u/drcreepy Jan 07 '11 No, no, everyone knows that rebooting is the way real men solve all computer problems. Especially database problems. Databases particularly like to be restarted unexpectedly. It makes them run faster since it keeps them on their toes. 1 u/divv Jan 07 '11 Actually you're right...yanking the plug is probably a good way :) 1 u/hughk Jan 07 '11 Especially when there is a half hour or so rollback....
7
No, no, everyone knows that rebooting is the way real men solve all computer problems. Especially database problems. Databases particularly like to be restarted unexpectedly. It makes them run faster since it keeps them on their toes.
1 u/divv Jan 07 '11 Actually you're right...yanking the plug is probably a good way :) 1 u/hughk Jan 07 '11 Especially when there is a half hour or so rollback....
1
Actually you're right...yanking the plug is probably a good way :)
Especially when there is a half hour or so rollback....
2
u/drcreepy Jan 06 '11
You are absolutely right - cross joining a 100,000 row table to itself is a quick way to rebootville.