The Southeast's premier PHP community

IMPORTANT DATE CHANGE – August Meeting moved to the 14th

IMPORTANT – We will NOT be meeting on August 7th. Our next meeting has been rescheduled to August 14th to accommodate our special speaker, Jay Pipes from MySQL.

When: Thursday, August 14, 2008 — 7pm-9pm
Where: Consulate General of Canada

Presentation: Join-Fu: The Art of SQL

Jay Pipes, the North American Community Relations Manager at MySQL and co-author of Pro MySQL (Apress, 2005), joins us this month to present “Join-Fu: The Art of SQL.

Join-fu is the art of performance-tuning your application’s SQL. Join Jay in a fun, irreverent look at the common ways application developers misuse and abuse their database.

Topics covered include:
  • Schema optimization and vertical partitioning
  • SQL Coding style guidelines
  • Set-wise problem solving in SQL (and why it kicks for-loop-fu’s ass.)
    • Rewriting correlated subqueries into joins
    • Using derived tables or subqueries in the FROM clause
  • Working with N:M or “mapping” tables
    • Dealing with OR conditions
    • Dealing with AND conditions
    • Combatting filesorts using Cross-join-fu
  • Understanding Left-join-fu
  • Handling Heirarchical Data
    • Adjacency Lists
    • Nested Sets
  • Doing GIS calculations in SQL
    • Without using user variables, the spatial extensions or stored functions
    • Calculating distance between two points
    • Doing radius searches in spherical geometries
  • Reporting techniques in SQL
    • Calculating running sums and aggregates
    • Calculating rank of results


Our meeting takes place at the Consulate General of Canada at 100 Colony Square in Midtown Atlanta (at the corner of Peachtree and 14th Streets). Click here for directions. You will need to see the concierge in order to gain access to the 17th floor.

Comments are closed.