Speed Up Bulk Inserts with FireDAC Array DML in RAD Studio
Reduce database round trips when inserting many rows with FireDAC Array DML, then verify driver support before production.
Loading…
ReadMeFeed / Community knowledge
#firedac
Real questions. Useful conversations. Find the people who know your stack.
delphiDelphi FireDAC Connection Pooling: An Architecture Note for Bounded Concurrency
A Delphi service that opens a connection per request or shares objects across threads will exhaust pools and leak handles. Use one pooled FireDAC connection per logical request, explicit transactions, parameterized SQL, and a least-privilege database identity.
FireDAC Array DML: Batching Delphi Inserts to Cut Network Round Trips
Row-by-row inserts in Delphi often bottleneck on network round trips. FireDAC Array DML batches them into a single call, but memory and error-handling trade-offs apply.
Use FireDAC Array DML to write many rows in one Execute call
Batch inserts, updates, and deletes with RAD Studio FireDAC Array DML to cut database round-trips.
The Delphi Search Box Problem: Parameterizing FireDAC Queries by Default
Concatenating user input into SQL strings is a liability. See how to use TFDQuery parameters in Delphi to separate code from data, reduce injection risk, and avoid type-mapping surprises.
Server-Side Pagination in Delphi with FireDAC LIMIT and OFFSET
Fetch only the rows your Delphi grid needs by binding PageSize and Offset to FireDAC TFDQuery, with limits and verification steps.
FireDAC as a unified data access decision in RadStudio
FireDAC lets RadStudio apps keep data access code stable across desktop and mobile by separating connection, command and presentation, with driver swaps instead of rewrites.
radstudioEnable FireDAC Connection Pooling in Delphi Desktop Apps to Reduce Latency
Enable FireDAC connection pooling in Delphi VCL/FMX apps to reuse database handles, reduce open latency, and stabilize server connections under concurrent load.
FireDAC Connection Pooling for PostgreSQL: Configuration, Limits, and How to Verify It Works
A practical look at configuring FireDAC connection pooling for PostgreSQL in RAD Studio, including sizing trade-offs, session-state pitfalls, and verification steps.