Going to Atlanta (via php|works)!
Two of my proposals were accepted to the php|works 2007 conference! w00t! The talks that were accepted were: You Don't Need a DBA or What Every PHP Developer Should Know about Database Development No amount of optimizing can be a substitute for proper design. This talk will focus on good practices when designing a database, ranging from learning how to preserve referential integrity, through proper indexing to optimizing techniques such as denormalization. This talk is meant for developers who would like to make the jump from writing basic SQL queries to more advanced database tasks. How to Optimize a Database Query Through a series of examples, this talk will explore how a database query can be optimized for the specific task it is meant to perform. Common themes when optimizing queries: learning what kind of data to expect, assessing your needs, finding the balance between not enough and too many indexes, and utilizing alternate solutions such as denormalization. As the sample queries are dissected to make them better and faster, I will use Oracle's EXPLAIN PLAN to illustrate how the database is attempting to retrieve data. Now I gotta go practice public speaking...
Comments (0)