Performance problems are often caused by poorly formed SQL statements.
Tag Archives: performance
Mind the 7 P’s.
“Proper planning and preparation prevents piss poor performance.” – British military adage.
Don’t put queries in loops.
Poorly designed database queries are the leading cause of performance problems.
Tighten your loops.
For performance and simplicity.
Performance tuning is dangerous.
Don’t attempt it unless it’s really going to be necessary.
Keep out of the loop.
This is a simple database optimization many people overlook.
Leverage the ORM.
Use relationships to reduce queries.
Use instrumentation.
Don’t try to optimize your application by guessing which part is slow.
Avoid premature optimization.
There’s a time and a place for this and it’s not at the beginning.