SQL Performance
Progress DataDirect Drives the Best SQL Performance
For modern enterprise applications, performance and scalability often come down to how quickly and efficiently SQL operations can be executed against the back-end relational databases. Progress DataDirect elevates enterprise service quality with standards-based data drivers that not only deliver better SQL performance than competing drivers, but also surpass the SQL performance of coding to native database APIs.
Better SQL Performance than Other Drivers
Comprehensive benchmarking tests demonstrate that DataDirect's ADO.NET, ODBC, and JDBC drivers top all other drivers when it comes to SQL performance. For example, in a recent test of ODBC driver SQL performance across a variety of database operations including selects, inserts, updates, and deletes, DataDirect drivers not only delivered better throughput than competing drivers (as much as 125% more), they also bested other drivers on CPU efficiency and minimizing memory usage – key considerations for virtualized environments in particular.
On the JDBC side of things, DataDirect is the SPECjAppServer/ECPerf performance benchmark leader.
DataDirect's Microsoft ODBC drivers and other standards-based drivers achieve better SQL performance because of their innovative wire protocol design that eliminates the need for performance-clogging database client libraries; and because of tunable driver-implemented performance features like connection pooling, statement pooling, load balancing, and bulk loading.
Better SQL Performance than Directly Using Database APIs
A recent independent benchmark study by database expert Ken North found that across a variety of databases and a range of SQL operations, DataDirect drivers delivered better overall SQL performance than did programming to the native database API.
This SQL performance superiority over native database API programming is possible because of the many performance-optimizing features built into DataDirect drivers. For example, DataDirect's architecture allows data packets to be compressed, which speeds transmission across the wire.
At the same time, by using DataDirect drivers rather than native DB interfaces, your applications can interoperate across different database types without any need for code changes. DataDirect drivers maximize cross-database application interoperability with features like SQL up-leveling and standardized handling of database connect error conditions.
Top SQL Performance for Any Database
Progress DataDirect offers the most comprehensive line of standards-based data drivers in the industry. From our ADO.NET, JDBC, and ODBC download center you can do an ADO.NET, JDBC, or ODBC driver download and give the driver a test run in your own environment at no cost. We have drivers for every data access architecture from MS SQL Server ADO.NET drivers for Windows to Oracle ODBC Unix drivers.
Download a DataDirect driver now to start a free 15 day trial.
Contact us to learn how we can help you meet your data connectivity challenges.
