The duration of a CodeRage Conference presentation is generally 45 minutes. Each replay includes video and audio.
Your Search Keywords: REQUIREMENTS
Deploy Top-Performing SQL Code with DB Optimizer
Greg Nerpouni – Embarcadero
Relevant to: Delphi, Delphi
Yikes! Your application just failed three performance requirements in QA. Is it your database? Is it your application? What is it? Before you begin the usual "hair on fire" drills - tuning the parameters, rebuilding the indexes, removing them, and throwing more hardware at the problem - attend this session presented by Greg Nerpouni, Product Manager. Learn best practices for uncovering inefficiencies in your SQL queries earlier in the development lifecycle - to prevent poor-performing SQL from reaching your production environment where it is significantly more costly to fix.
Firebird is a relational database system, that suppports most ANSI SQL features. The open source project started in the year 2000 based on the source code of Borland InterBase. Firebird uses a free license, which also allows unlimited usage and distribution in commercial projects. Starting with a small embedded version up to the full featured server version available for Windows, Linux, Mac, Sun, etc., it can be easilly included in distributed applications. Holger gives an overview about customer projects where Firebird is used and the new Firebird driver available in Delphi 2010. You also get an overview about important features like stored procedures, triggers, views, hardware requirements, administration, scalability, differences from InterBase, MySQL and Postgresql, etc.