Yamaha chose the Progress DataDirect product because they are designed for optimal database access performance on virtual machines (VMs). DataDirect takes a resource-efficient approach to architecture. The DataDirect drivers that Yamaha selected were designed to make the most efficient possible hardware-based resources such as CPU, memory, and network I/O capacity. Better hardware performance leads to improved application performance on the VM that runs the application. The DataDirect drivers also feature a streamlined, clientless design that communicates with the database at the lowest level possible, the “wire protocol”. This design eliminates the need for database client libraries, reducing the administrative overhead of managing multiple vendors and versions of cumbersome database client installations and the amount of excessive network “chatter”.
Compared to other JDBC drivers, DataDirect’s Type 5 products demonstrate unmatched throughput. On average, DataDirect JDBC drivers can process 20-500% more work in a given time period than is possible with competing products. For example, in a test that simulates a monthly report in which many records are fetched, the DataDirect driver is up to 1450% faster. And in most tests, DataDirect driver throughput stays high and even increases as more users are added. DataDirect drivers also use considerably fewer CPU cycles to deliver superior throughput than competing drivers—in many cases, greater than 150% more CPU efficient. Finally, DataDirect drivers require significantly less memory while doing more work than performance-limiting Type 4 drivers—in some cases saving over 400% in memory.
Making the Database Hum with Progress DataDirect JDBC Drivers
After using the wizard-based installation process, which took the Yamaha database administrator about an hour, the Tomcat-based version of the dealer site came back to life. The database stopped crashing and the application returned to its previous level of stability. After tuning the driver, including tweaking some “hidden” settings by working in concert with the Progress support team, the dealer site was able to function at a 20 times the speed it had been running with the Microsoft SQL Server drivers! The improved data access helped actual page load times increase by a factor of 10X.
“We collaborated with the Progress Support team on tuning the drivers and got a 20X improvement in database access performance!” said Ronald Haring, Senior Developer, Yamaha Motor Europe. “DataDirect’s ‘Statement Pooling’ capability was a big factor in this remarkable performance leap. Pages now loaded in between four and five seconds.” The DataDirect product was also able to help Yamaha with a smooth transition to launching the new dealer site in 12 different languages. Some of the countries where Yamaha does business have UTF8 characters, while others have Unicode. The SQL Server drivers had had trouble with this, but DataDirect JDBC drivers made it possible to get the site up in all territories easily.