Manny Vergera shares a different approach to optimizing throughput, attacking the problem through ODBC/JDBC connectivity rather than CPU or RAM.
The impact of Michael Jackson’s untimely 2009 death didn't only affect his fans worldwide—it also served as a wake-up call to retail companies to keep up with online demand.
Sony had the rights to sell most of Jackson’s albums online. As millions of fans converged on Sony’s website to buy his music, the servers collapsed, unprepared for the massive purchasing request.
The fallout continued:
Sony lost millions because it didn’t have the capability to sustain the amount of traffic and purchasing requests for Jackson’s music.
Imagine if this happened to your company? Are you prepared for it? What happened to Sony Music is not unique. Similar situations happen every day. Company servers get stalled, or the number of CPU threads allocated to critical application or databases are configured incorrectly or RAM memory runs out.
CPU and RAM use won’t improve unless you look at the root problem that exists at connectivity and integration between the application and database access.
Most database vendors offer ODBC and JDBC connectivity using proprietary libraries. These slow down the computing and processing power available to execute the correct amount of CPU threads at a given moment. Instead, it generates a phenomenon called Processor Affinity or CPU pinning, where the process or thread will execute only on the designated CPU or CPUs rather than on any CPU.
Progress DataDirect takes a different approach to CPU and RAM optimization in your physical or virtual server. DataDirect uses Wire Technology, which allows the execution of CPU threads to connect directly to the database via standard ODBC, JDBC or ADO.NET protocols without having to execute the instructions of the database libraries.
Plus, DataDirect uses the Bulk Load feature for inserting very large numbers of records into a database as quickly as possible. It can reach up to 30X the throughput and optimizes CPU and RAM performance.
Anatomy and Features Inside the DataDirect Driver
With Progress® DataDirect® using Bulk Load, companies effectively satisfy the bulk data access requirements for a broad array of data access use cases. In doing so, they simplify the data access architecture, save important resources for other tasks and improve operational performance including the following scenarios:
Our Clients and Partners Rely on Us
Progress DataDirect increases efficiency, uses the best technology in wire protocol and gets the most out of computing resources when applications connect to databases via ODBC, JDBC and ADO.NET standards. It leads the industry and can reach up to a 30X improvement in performance.
Progress DataDirect is a powerful solution for many needs:
We're always happy to help you get the most out of DataDirect. If you have any questions, just let us know or reach out to us in the comments below.
Trusted advisor at Progress specialized in data connectivity and integration solutions ready to solve complex customer’s problems in ETL, Cloud Applications, Databases, Data Security, Mobile Applications, Software Defined Data Centers Data Orchestration, Big Data, Rapid Application Development And Modernization of Legacy Systems. Manny is also cloud network specialist available to assist companies to increase data connectivity performance, security and productivity in multi-tenancy environments, best use of provisioning of computing resources on-demand, and effective migration to cloud computing solutions.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.