Going to Atlanta (via php|works)!
by maggie on Jul.02, 2007, under entry
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…
-
-->
Recently Linked From- Kühle URLs November 19, 2009Nochmal alle zusammen, und drei, vier: "Cool URLs don't change!" (genauer: Cool URIs don't change), wie schon der Erfinder des Internet, Al Gore Tim Berners-Lee forderte, der damit erreichen will, dass Inhalte immer im Netz auffindbar ... […]Konstantin Klein
- ORM в мире PHP October 21, 2009ORM (англ. Object-relational mapping, русск. Объектно-реляционная проекция) — запись объектов программы в реляционную базу данных, отображение объекта и его представления в виде набора таблиц. – Википедия: ORM ... […]ingvar
- “Micro” Optimizations That Matter October 16, 2009Every few weeks, someone publishes an article talking about how it's faster to use single quotes rather than double quotes and how you should use echo() instead of print(). Most of these are bunk; that is, the time we spend talking ... […]Brandon Savage
- Tour du mois en PHP : mars 2009 April 20, 2009Comme tous les mois, en voici un nouveau qui s'est achevé — avec sa quantité d'articles et d'événements intéressants ! Voici ma compilation de liens m'ayant le plus marqués pour le mois de mars 2009. ... […]Pascal MARTIN
- stop sacrificing readability for efficiency! March 26, 2009much was made last week over the topic of micro optimization in php. most of these argued that micro optimization was a bad idea, from the perspective of unit testing, the idea that “premature optimization is the root of all evil”, ... […]Brandon Savage
- Kühle URLs November 19, 2009
