Speed Up RAD Studio Database Code with FireDAC Prepared Statements and Connection Pooling
Learn how to cut query latency in RAD Studio by preparing FireDAC statements and reusing connections with pooling.
Loading…
ReadMeFeed / Community knowledge
#firedac
Real questions. Useful conversations. Find the people who know your stack.
radstudioArchitecture Note: Minimal FireDAC Design for RadStudio Delphi Applications
A concise architecture note outlining the smallest FireDAC‑based design for RadStudio Delphi apps, covering requirements, trust boundaries, checks, failure modes, and triggers for redesign.
delphiChoosing a Database Access Layer in Delphi: FireDAC vs. dbExpress
A technical decision guide for Delphi developers comparing FireDAC and dbExpress for database access, focusing on features, deployment, and modern compatibility.
Speeding Up Bulk Data Loads in RAD Studio with FireDAC Array DML
Learn how FireDAC Array DML in RAD Studio reduces round‑trips and speeds up bulk inserts, updates, and deletes, with a concrete CSV‑to‑SQL Server example and guidance on transaction handling and limits.
One Codebase for Desktop and Mobile in Rad Studio with FMX and FireDAC
Keep business logic in shared FireDAC DataModules and UI in FireMonkey FMX, with platform style hooks. Use LiveBindings and IFDEFs to isolate variance for Windows, macOS, iOS and Android.
Improving Delphi Database Access with FireDAC Connection Pooling
Learn how to enable and tune FireDAC’s built‑in connection pooling to cut latency and avoid exhausting database connections.
FireDAC Architecture in RAD Studio 10.4+: Connection Management and Operational Boundaries
An architectural guide to FireDAC in RAD Studio 10.4+, covering connection pooling, trust boundaries, failure modes, and operational verification for multi-DB apps.
FireDAC Prepared Statements: What TFDQuery.Prepared Actually Changes
TFDQuery.Prepared is a request to the driver, not a speed switch. Here is what it changes, where the gain is real, and how to confirm prepare/execute behavior.
Resolving FireDAC Connection Pool Exhaustion in RAD Studio
Diagnose and resolve EFDConnPoolException in RAD Studio. This guide covers identifying connection leaks, tuning MaxPoolSize, and using FireDAC tracing to stop pool exhaustion.