New in Delphi DAC: Support for RAD Studio 10.4.2 and Multiple Performance Improvements
Tags: delphi, mysql, sqlserver
Published: 2021-03-25 18:39:12

Following the release of RAD Studio 10.4.2 Sydney from last week, we are excited to announce support for the [new versions of Delphi](https://blog.devart.com/delphi-dac-support-for-rad-studio-10-4-2.html) and C++ Builder IDEs in our data access components. DAC products are now also compatible with macOS Big Sur, iOS 14, and Android 11. Additionally, PostgreSQL 13 was supported in PgDAC.


Data access speed with default settings was significantly increased in LiteDAC and the SQLite provider. The performance of batch operations was improved in all [DAC products](https://www.devart.com/dac.html). During batch processing, SQL statements are grouped into a single unit of work, known as a batch, and submitted to the database server in a single call, thereby reducing the network latency. We also reduced memory consumption in batch operations for InterBase and Firebird.

The LOBs read/write speed was improved for Oracle, SQL Server, DBF files, and ODBC drivers. The data fetch speed was also improved for Oracle and ODBC drivers. The PrefetchRows property, which allows you to set the number of rows to be prefetched during query execution, was supported in the Direct mode (previously available only in the OCI mode). The FindFirst, FindNext, FindLast, and FindPrior methods to search for records in a dataset using filters now work much faster in all DACs.

The Over-the-Wire (OTW) encryption feature of InterBase was supported in IBDAC to allow you to secure your data during the transmission process with SSL/TLS encryption. Also automatic detection of computed fields when generating update statements was improved in IBDAC.

In PgDAC, a single TPgConnection object can now be used in multiple threads, and a new property called MultipleConnections allows or denies creation of additional internal connections.

Three new properties were added in LiteDAC: JournalMode, LockingMode, and Synchronous. The Unicode standard was supported in the TVirtualQuery component. The LastWarningCount property and the OnWarning event were added in MyDAC to get the number of warnings received from the MySQL server and define an event handler method.

Devart Delphi Data Access Components are suites of components for direct access to common databases and cloud services and allow creating multi-platform database applications in Embarcadero RAD Studio, Delphi, C++Builder, Lazarus, and Free Pascal for Windows, Linux, macOS, iOS, and Android, both 32-bit and 64-bit.

To try out these features, you are welcome to download new versions of Devart data access components:
[UniDAC 8.4](https://www.devart.com/unidac/)[[ Download ]](https://www.devart.com/unidac/download.html)
[ODAC 11.4](https://www.devart.com/odac/download.html)[[ Download ]](https://www.devart.com/odac/download.html)	
[SDAC 9.4](https://www.devart.com/sdac/)[[ Download ]](https://www.devart.com/sdac/download.html)	
[MyDAC 10.4](https://www.devart.com/mydac/)[[ Download ]](https://www.devart.com/mydac/revision_history.html)	
[IBDAC 7.4](https://www.devart.com/ibdac/)[[ Download ]](https://www.devart.com/ibdac/download.html)	
[PgDAC 6.4](https://www.devart.com/pgdac/)[[ Download ]](https://www.devart.com/pgdac/download.html)
[LiteDAC 4.4](https://www.devart.com/litedac/)[[ Download ]](https://www.devart.com/litedac/download.html)
[VirtualDAC 11.4](https://www.devart.com/virtualdac/)[[ Download ]](https://www.devart.com/virtualdac/download.html)