News for hackers. Stuff that matters.

A comment on Ask HN: My web startup is growing fast what next?.

Re:Ask HN: My web startup is growing fast what next? by badkins on Friday February 18, 2011 @10:44AM (#2235817)
When optimizing, don't do it blindly. Do some actual tests or profiling to find the true bottleneck. It might be a specific query, the DB as a whole, etc. But unless you fix the biggest bottleneck, other improvements won't make much diference. Once you fix the biggest bottleneck, go back and do it again for the next biggest.

This way, you will know for sure if you need another machine, more RAM, or just another table index.

[ Parent | on HN ]
Re:Ask HN: My web startup is growing fast what next? by digamber_kamat on Friday February 18, 2011 @12:05PM (#2236227)
Yes true. I realized this during my initial optimization. I realized that some queries involving joins were taking unusually long time, a slight tweaking tremendous gain in performance.
[ Parent | on HN ]