"In a typical web app, HTTP optimization and doing O(1) queries rather O(n^2) pe...

Hacker News

"In a typical web app, HTTP optimization and doing O(1) queries rather O(n^2) per page is where performance lies"

Yes, I have found 99% of my speed increases from good database indexing and using hashtables to store data you need more than once.

steve 2860 days ago

Indeed, databases are real root of all performance problems. I rewrote a site to use the database much less frequently (mostly just for the initial loading and write operations) and I've been incredibly satisfied with the results.

-----