Behind the Brain

SELECT * is evil

It is one of the first rules one should learn when using SQL: SELECT * is evil. Yes it is.

But I must admit that this site used it at many places. This is because I mostly hacked this together without any optimizations in sense. But today I was a little bored and worked a bit on the site.

I started replacing SELECT * by proper queries and even on this small site with just some queries the loadtime dropped by 20% :)

I think I'm going to put a Post-It on my monitor say "SELECT * is evil" ;)

Some other changes I made: I removed the "Home" page of this site since it was useless anyway. Then I fixed a small security hole which I hope wasn't used :) And then I found a bug concerning comments for news. At some conditions it was impossible to post a comment to a news which should be fixed now.

And yes I know I haven't been very active in the last time. But I hope I can change this in the future. Well in two week I'm on holiday for three weeks, but after that I will try to be more active.

In the due time I'll implement the support of comments for IrrIni (finally). Shouldn't take too long but I'm a lazy a** ;)

Happy coding ;)

Jul 8th 2009, 19:04 by Sylence.

Back to top