Hi All,

We invite all Firebird developers and administrators to 1-day seminar in the frames of Firebird 2015 Tour.  Firebird 2015 Tour is devoted to the SQL performance optimization:  SQL plans, queries and database statistics, query tuning techniques and deep understanding of undercover work of Firebird.

Firebird 2015 Tour is organized by IBSurgeon and IBPhoenix, with support of Firebird Developers 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:

1)    Performance of SELECT queries
 a.    PLANs: what are INDEX, SORT, ORDER, NATURAL and how to manage them
 b.    Execution statistics interpretation, data paths, cache hits
 c.    Tracking slow and resource-consuming resources through MON$ and Trace API
 d.    Firebird configuration parameters
 e.    Best practices, tips and tricks to speed up queries

2)    Performance of INSERT queries
 a.    Typical errors which lead to slow INSERTs
 b.    How indices, triggers and database structure affect INSERT performance
 c.    Transactions and INSERTs
 d.    Best practices to speed up INSERTs

3)    Performance of UPDATE and DELETE queries
 a.    General approach for updates and deletes
 b.    How indices, triggers and database structure affect UPDATE and DELETE performance
 c.    Update Conflicts, transactions and their resolution, DELETE, SELECT WITH LOCK
 d.    Real-life example of UPDATEs algorithm without conflicts
4)    Multi-user performance optimization
 a.    Locks, mutexes and races for resources
 b.    Selecting Firebird architectures and tuning their parameters for multi-user environments
 
Locations details for Firebird 2015 Tour

April 24, Seligenstadt, Germany

Seminar will take place in Hotel Columbus (www.hotel-columbus.de/contact.php/), April 24, 2015.
Important! 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).
https://secure.shareit.com/shareit/checkout.html?productid=300604679

May 19, Prague, Czech Republic

Seminar will take in the Hotel Extoll Inn (http://extolinn.cz/en/contact.htm),  May 19, 2015.
 Important! 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)
https://secure.shareit.com/shareit/checkout.html?productid=300660565

June 5, Moscow, Russia

Seminar will take place in TechnoPark «Slava» (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).
https://secure.shareit.com/shareit/checkout.html?productid=300604678

Для получения российского счета на оплату напишите sales@...


Questions?

Feel free to ask any questions at firebird2015@...


Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com