In my experience, the biggest impact on your (relational) database performance you can make by putting in correct indexes essentialsql.com/what-is-a-databas...
That is obviously only true for read operations, but most web apps do more read operations that write operations
In my experience, the biggest impact on your (relational) database performance you can make by putting in correct indexes essentialsql.com/what-is-a-databas...
That is obviously only true for read operations, but most web apps do more read operations that write operations
It's not everything, in first place you need to prepare correct data models, indexes are very important but you need to think much deeper.