Random notes on database features, code, practice, optimization and techniques.
Happy St. Patrick's Day people!
A bit busy to prepare a presentation on a site's "legacy performance issues" for the Managers and developers. A very first frill free draft can be read
here.
This is supposed to be an one-hour long very high level overview of the mistakes (performance perspectives) the developers have been doing time and again. After solving hundreds of pieces of code and performance issues, I figured out that things are coming to a full circle. Same mistakes are being committed in the later branches - which I've already went and fixed in the earlier.
Thus had a long talk with managers and figured it would make perfect sense to pick a few "critical" and "recurring" issues and update the guys who actually can take ownership of this while developing.
Will keep writing on this more. Remember, though this is a very site-specific thing, in my eight years - most of these issues (and many more) always revisit me!!