Database Wizardry for Legacy Applications

Explore database optimization techniques for legacy applications in this 37-minute conference talk from PHP UK Conference. Learn how to overcome bottlenecks and improve performance without major structural changes. Discover the benefits of NoSQL databases for data consolidation and the power of MapReduce for enhancing project efficiency. Delve into topics such as database scaling, binary trees, dimensional tables, and text search. Gain insights on handling money transactions and addressing passive aversion in legacy systems. Master the art of database wizardry to transform spaghetti code into a well-structured, high-performance application.

Introduction
Who am I
Respect
Legacy Applications
Database Optimization
Database Scaling
Database Structures
Binary Tree
Improve Database Performance
What to Learn
Money Transactions
Dimensional Tables
QueryMongo
Passive Aversion
The Best Solution
Text Search
Conclusion