Remdex site / blog

 There are many articles regarding this topic e.x:

Mysql performance blog article
Book chapter
http://www.slideshare.net/techdude/how-to-kill-mysql-performance

So what else can be done? Actually two things

Small exercise witch recently helped me. Let say we have column with values 5,1,2,1,3,4,8 and we need, that Mysql or PostgreSQL order it such sequence 2,3,4,5,8,1,1 this means, if price is < 2 $ we should put it in the back.
Want answer ? Read more…