Power Workshops (Monday, Nov. 6, 2006)

Type Title Speaker
Tutorial (full day, 6 hours) Firebird for Professionals Klemt
Tutorial (half day, 3 hours) MySQL Performance Optimization Zaitsev
top

PWM1: Firebird for Professionals

Speaker:
Tutorial (full day, 6 hours)
Description:

Part 1. optimize SQL commands, plan, statistics, performanceanalysis and -optimization
Compare sql commands, indexplan, udnerstanding the optimizer, reads, writes and fetches,
datamodel, updatable views, procedures as replacements for complex joins, understanding differences subselects, in, exists, <>, containing, like, transactions, MGA, SQL monitor

Part 2. Import, export, reporting, web, BDE replacement, native libraries, Datatypes, import paradox, dbase, msaccess, csv, txt, other formats, export, using odbc, external files, character sets, IBObjects, TDataset, automatic convert from BDE using greplace, FIBPlus, Zeos, Jedi, Query and SQL components, transactions, sessions, bde params, simple and advanced reports using fastreport, dynamic webapplications using javascript, ajax, php, ibewebforms

Details:
top

PWM2: MySQL Performance Optimization

Speaker:
Tutorial (half day, 3 hours)
Description:

This tutorial goes into the details of MySQL Performance Opimization. Starting with basics of MySQL Server configuration it covers schema design and indexing strategies, query optimization and profiling, using replication to arhive high performance and high availability. We also speak about application architecture design, hardware platform selection, deployment, and backup strategies.

Details: