Home
>
Software
>
Performance Tuning of a Daffodil DB / One$DB -JDBC Application

Performance Tuning of a Daffodil DB / One$DB -JDBC Application

This article illustrates the best practices to improve the performance of Daffodil DB / One$DB JDBC Driver. This article focuses on how to improve the performance of a Daffodil DB / One$DB JDBC application using Statement, PreparedStatemnt, CallableStatement and ResultSet interfaces. Choosing the right statement interfaces and right methods according to your SQL query plays a vital role in improving the performance of a JDBC Driver.

JDBC Overview

JDBC API provides standard set of interfaces to work with databases like Daffodil DB / One$DB, Oracle, Derby etc.

Connection interface encapsulates database connection functionality, Statement interface encapsulates SQL statement representation and execution functionality whereas ResultSet interface encapsulates retrieving data which comes from the execution of a SQL query using Statement.

Following are the basic steps to write a JDBC program.

1. Import "java.sql" and "javax.sql" packages. (Import "javax.sql", if advanced JDBC feature like XA is to be used)

2. Load Daffodil DB JDBC driver (embedded or network JDBC Driver)

3. Establish connection to database using Connection interface

4. Create a Statement

5. Execute the Statement

6. Retrieve results by using ResultSet interface

7. Close Statement and Connection

Choosing right Statement interface:

There are three types of Statement interfaces in JDBC to represent/execute a SQL query-Statement, PreparedStatement and CallableStatement. Statement is used for executing static SQL statement with no input and output parameters; PreparedStatement is used to execute dynamic SQL statement with input parameters whereas CallableStatement is used to execute dynamic SQL with both input and output parameters. One important thing to note about PreparedStatement and CallableStatement is that they can also be used for static SQL statements. However, CallableStatement is mainly meant for stored procedures.

PreparedStatement gives better performance when compared to Statement because it is pre-parsed and pre-compiled. This means that compilation and parsing of such statement is done only once by the database. Afterwards the database reuses the already parsed and compiled statement. This significantly improves the performance because whenever a statement has to be executed repeatedly, it doesn't need to be parsed and compiled time and again. So the overload incurred by parsing and compiling the same statement can be reduced.

When there is a requirement for single request to process multiple complex statements, CallableStatement gives better performance as compared to PreparedStatement and Statement.

To read the full article please visit http://www.daffodildb.com/daffodildb-performance-tuning.html

This article has been contributed by (Mr.) Parveen Aggarwal, Technical Consultant to DSL India (http://www.daffodildb.com). With more than 6 years of industry experience in Java and allied technologies, he has an in-depth understanding of J2EE, J2ME and database management systems. Parveen is currently working on the concept of data-archiving in embedded databases. He can be contacted at http://www.daffodildb.com

Benton shuttle to Midway .. Lockport Chicago limo O’Hare

In The News:

Just two months into 2025 there have been numerous Mac malware threats targeting Apple laptops, ranging from infostealers to malicious software.

A self-driving electric bus powered by artificial intelligence has an electric powertrain for zero-emission operation and an automated drive system.

SpaceX is slated to launch its Starship for the eighth time from Boca Chica, Texas, Friday, though plans could be thwarted if the FAA fails to give the green light.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Kurt the CyberGuy offers tips on how you can protect your devices against infostealer malware, which was used to infect 4.3 million machines last year.

Motional is developing autonomous vehicles capable of handling a wide range of real-world scenarios. Its high-speed robotaxi testing reached speeds of 75 mph.

Kurt "CyberGuy" Knutsson explores whether there is artificial intelligence bias involved with the iPhone's voice-to-text conversion in the message app.

Apple's iPhone voice-to-text periodically flashes "Trump" when a user speaks the word "racist." Fox News Digital reached out to Apple about the flaw but did not hear back.

Tech expert Kurt “CyberGuy" Knutsson presents five secret shortcuts: Adjust sound/vibration, share YouTube moments, fix tabs and tweak brightness.

VR transforms senior care: Kurt “CyberGuy" Knutsson says immersive tech helps older adults explore and connect via virtual experiences.

Tech expert Kurt “CyberGuy" Knutsson says DNA tests pose privacy risks like shared genetic information, inaccuracies and hard data deletion.

Tech expert Kurt “CyberGuy" Knutsson says this enormous airship revolutionizes cargo transport by flying to remote areas.

Understanding the language of the internet can help you protect your personal information from bad actors. Kurt "CyberGuy" Knutsson explains.

Woven City is Toyota's experimental city that is a fully functional environment for people to live, work and play while doing research.

The line between spam and scams is thin. Kurt "CyberGuy" Knutsson details his tips for identifying and avoiding phone scams, robocalls and unwanted solicitations.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents

Kurt the CyberGuy takes you through the steps to easily set your preferred web browser whether you're using a Mac, Windows PC, iPhone or Android.

Google, Instagram, Facebook and weather apps can track your location and use that data to serve you ads; here's what you can do to protect your privacy.

A new debate has emerged about whether airlines should charge passengers based on their weight to help reduce fuel consumption and lower emissions.

Tech expert Kurt “CyberGuy" Knutsson says Hipshipper, which is used by eBay, Shopify and Amazon sellers, exposed millions of shipping labels.

Boxabl’s Baby Box is a 120-square-foot foldable home that can be set up in 60 minutes and has off-grid features. Kurt “CyberGuy" Knutsson says it's designed to maximize functionality.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Major IoT data breach: Mars Hydro database with 2.7 billion records exposed. Kurt “CyberGuy" Knutsson says the breach is a reminder of the risks that come with using IoT devices.

Unitree H1 robots dance at gala, blending AI and tradition. Tech expert Kurt “CyberGuy" Knutsson examines the convergence of cutting-edge technology and traditional culture.

For the first time ever, SpaceX launched a rocket into space from Florida and landed the booster the Bahamas, allowing for future polar-orbit spaceflight missions.

Performance Tuning of a Daffodil DB / One$DB -JDBC Application

Software