File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC" Watch "JDBC" New topic


janaka chandrajith
Ranch Hand

Joined: Jul 04, 2007
Posts: 35
Dear All,
There is a java standalone application which reads data from a raw file and
inserts into an Oracle database.It is reqiured to improve the performance of this application.
the connection is JDBC.
data is being checked for duplication.
what are the metodolgies to improve the performance of this application?
connection pooling , multithreading.....
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3749

There are an unlimited numbers of ways to improve performance in a database application, so you'll need to provide a lot more specifics if you want some help. Is there a specific type of query you're seeing poor performance with?

[OCA 8 Book] [Blog]
It is sorta covered in the JavaRanch Style Guide.
subject: JDBC
It's not a secret anymore!