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
Для получения российского счета на оплату напишите sa...@ibase.ru
Questions?
Feel free to ask any questions at firebird2...@ib-aid.com
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
