[themonk]

I have seen both extreme: no index v/s all column indexed, no cache at all v/s cache at every level.

I have seen caches having more inserts v/s reads.

I have seen them replacing MySQL by NoSQL as it does not scale for them.

This is common for early stage funded startups founded by non tech founders.

[raverbashing]

Oh I can imagine the pain...

"Let's make our change password system handle 100k requests per minute but the front page starts to get wonky at 1000 req/min"

[themonk]

This sounds familiar. Few day ago i over overheard this, "Our user authentication system is on MySQL, it may not scale, let's move it to NoSQL."

Only time this table is touched to check user entered correct password or not.