Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PreparedStatement.executeQuery slow

RP24Feb 28 2018 — edited Mar 2 2018

Hey,

I am using AppDynamics to instrument the code I have seen often in the reports that PreparedStatement.executeQuery(), PreparedStatement.executeUpdate(),  resultsSet.next() is very slow taking close to 350, 500 ms whereas the query takes only 10, 15 ms.

I am not sure what is causing slowness within PreparedStatetment.

Any pointers?

The database is oracle. Also we are using DBCP 1.4 connection pool

public ResultSet executeQuery(PreparedStatement statement)

   {

     ResultSet results = null;

     try

    {

       results = statement.executeQuery();   

     }catch(Exception e){

          //Exception handling

     }

return results;

}

}

Thanks!

Comments

Gary Graham-Oracle

Explicit export of user settings is currently only available for the connection information (for databases or SCM repositories like SVN). Of course, when moving between machines the user must decide whether the export processor strips out or encrypts any password information.

If you want to try moving other user settings between machines, I would guess zipping up just the xml files would be a good starting point.  Definitely avoid the system_cache folder.

There are lots of NetBean's related files, as discussed in DevFaqWindowsWstcrefAndFriends - NetBeans Wiki but I assume you can ignore those, too.

Edit:  and perhaps someday SQL Developer will support export like Data Modeler... How to export preferences? Preferences storage?

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 30 2018
Added on Feb 28 2018
4 comments
4,650 views