Firebird 2015 Tour: SQL Optimization: Germany, Czech Republic, Russia
We invite all Firebird developers and administrators to a 1 day seminar on the Firebird 2015 Tour. The Firebird 2015 Tour is devoted to SQL performance optimisation: SQL plans, queries and database statistics, query tuning techniques and understanding how Firebird works within this context.
The Firebird 2015 Tour is organised by IBSurgeon and IBPhoenix, with the support of Firebird Developer core team.
Locations and dates of Firebird 2015 Tour (see details in the appropriate sections below):
- April 24 - Seligenstadt, Germany
- May 19 – Prague, Czech Republic
- June 5 – Moscow, Russia
Topics of Firebird 2015 Tour seminar:
Performance of SELECT queries
1. PLANs: what are INDEX, SORT, ORDER, NATURAL and how to manage them
2. Execution statistics interpretation, data paths, cache hits
3. Tracking slow and resource-consuming queries through the MON$ and Trace API
4. Firebird configuration parameters
5. Best practices, tips and tricks to speed up queries
Performance of INSERT queries
1. Typical errors which lead to slow INSERTs
2. How indices, triggers and database structure affect INSERT performance
3. Transactions and INSERTs
4. Best practices to speed up INSERTs
Performance of UPDATE and DELETE queries
1. General approach for updates and deletes
2. How indices, triggers and database structure affect UPDATE and DELETE performance
3. Update Conflicts, transactions and their resolution, DELETE, SELECT WITH LOCK
4. Real-life example of UPDATEs algorithm without conflicts
Multi-user performance optimisation
1. Locks, mutexes and resource races
2. Selecting Firebird architectures and tuning their parameters for multi-user environments
Locations and further details for the Firebird 2015 Tour
April 24, Seligenstadt, Germany
The seminar will take place in Hotel Columbus (www.hotel-columbus.de/contact.php/), April 24, 2015.
Note: all topics are presented in English.
Seminar's schedule:
• 9-30-10-00 Registration
• 10-00 - 17-00 Seminar (with Lunch and Coffee breaks)
Attendee's package includes seminar’s materials, lunch and coffee breaks.
The early bird registration fee is EUR 49 (till April 5, volume discounts are available).
May 19, Prague, Czech Republic
The seminar will take in the Hotel Extoll Inn (http://extolinn.cz/), May 19, 2015.
Note: all topics are presented in English.
Seminar's schedule:
• 9-30-10-00 Registration
• 10-00 - 17-00 Seminar 10-00 - 17-00 Seminar (with Lunch and Coffee breaks)
Attendee's package includes seminar’s materials, lunch and coffee breaks.
The early bird registration fee is EUR 39 (till April 25, volume discounts are available)
June 5, Moscow, Russia
Seminar will take in TechnoPark «Slava» Inn (www.technopark-slava.ru/contacts), June 5, 2015.
Important! All topics are presented in Russian!
Seminar's schedule:
• 9-30-10-00 Registration
• 10-00 - 17-00 Seminar (with Lunch and Coffee breaks)
Attendee's package includes seminar’s materials and coffee breaks.
The early bird registration fee is EUR 39 (roubles 2800) (till April 25).
With best regards,
Firebird Project Team