[en3r0]

http://www.whenpenguinsattack.com/20...mysql-queries/


just saw it on digg, im no mysql expert, but maybe some of these tips could be useful to the devs?

[beatniak]

the digglink: http://digg.com/programming/10_tips_..._mysql_queries
more in depth: http://20bits.com/2007/04/10/10-tips...hat-dont-suck/
RTFM for optimalization: http://dev.mysql.com/doc/refman/5.0/...imization.html
more tips: http://forge.mysql.com/wiki/Top10SQLPerformanceTips

[kbeeveer46]

There is a front page story on digg right now that someone posted in response to the article you linked from Digg.

Justin Silverton at Jaslabs has a supposed list of 10 tips for optimizing MySQL queries. I couldn't read this and let it stand because this list is really, really bad. Some guy named Mike noted this, too. So in this entry I'll do two things: first, I'll explain why his list is bad; second, I'll present my own list which, hopefully, is much better. Onward, intrepid readers!

Link (down at the moment): http://20bits.com/2007/04/10/10-tips...hat-dont-suck/

Mirror: http://duggmirror.com/programming/10..._don_t_su ck/

[en3r0]

Yea, just saw that. Glad some people know what they are talking about. I should learn SQL...