Optimising the retrievial time from Oracle database

ananth

Hi All,
I have a java code that retrievies values from a table in a oracle database.

There are more than 100 columns and 100000 records for the table in the database and i am able to retrieve 88 records for 5 mins which doesnt suit the requirement.

I need to retrieve 300 records per minute is there any alternative available so that i can optimize the query or use any java methods to retrieve the values in the specified time

pls post any sample codes or links that will be helpful

Thanks in Advance!!!

r035198x

Quote:

Originally Posted by ananth

Hi All,
I have a java code that retrievies values from a table in a oracle database.

There are more than 100 columns and 100000 records for the table in the database and i am able to retrieve 88 records for 5 mins which doesnt suit the requirement.

I need to retrieve 300 records per minute is there any alternative available so that i can optimize the query or use any java methods to retrieve the values in the specified time

pls post any sample codes or links that will be helpful

Thanks in Advance!!!

If you suspect that it's your Java code which is causing the program to be slow then post that code and let's take a look at it.
Otherwise the optimization should have been done on the database itself as well. Perhaps the query you are using for retrieving is slow or maybe you need to create indexes e.t.c.

Optimising the retrievial time from Oracle database

re: Optimising the retrievial time from Oracle database

Similar Java bytes

/bytes/development

/bytes/it

/bytes/about