The duration of a CodeRage Conference presentation is generally 45 minutes. Each replay includes video and audio.
Your Search Keywords: QUERIES
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.
Relevant to: Delphi, RAD Studio
AnyDAC for Delphi introduced the Local SQL feature, allowing you to use TDataSet objects in SQL queries. Local SQL offers feature-rich SQL engine based on the SQLite query processor, good performance and stability. This session shows Local SQL applications, and explains how to configure and use Local SQL.