Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

SELECT *? A function in the SELECT statment?

Oh dear god, a blasphemer!

The former can cause performance problems if you have blobs as well as being an unnecessary security hole, the latter can cause performance problems over large datasets as it often forces the execution plan away from a set based solution.



The fact that using the most trivial of examples triggers a discussion in on itself helps to prove my point.

Nobody debates session.getUser(id)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: