java performance JDBC

[oiram]

Hello:

Has any you any idea about what can be done to improve the performance of a java application that connect to an Oracle database?

Regards.

[Deepak Extross]

Well, the first thing to do would be to identify the performance bottlenecks - is your application spending too much time in blocked waits (do you have many "synchroinised" blocks of code or methods), is there a number-crunching or sorting algorithm that you can improve, or are database operations your bottleneck? If it is indeed a DB-related issue, there are again many things to look at - are indexes being used correctly? Are the Database parameters optimised? Are your queries efficient?

In all probability, 80% of the time your application is executing 20% of the code, and that is where you need to focus.
Try using timestamp logs to zero in on the problem. You'll get much more useful advice in response to slightly more specific queries.

[oiram]

Hello:

Do you know is there is something that could make a java application run 5 times faster in a NT system than in a HP-UX system(this is my case).
No memory pressure and the processor is idle the most time.
With HPjmeter I have seen that the method that is called more times is:
oracle.sqlnet.SQLnetBufferedInputStream.read

Any ideas?


Regards.