performance problem with recordset object

Hi,

I have a performance problem with record set object. Is it true using RecordSet object as argument to the method will cause any perfomance degradation?

here is my code.

finStmtList = selectFinancialStatements(rs, shortFormat, latestOnly, true);

I changed the code by populating the recordset in the method that called the above statement. previously the population of valueobject is within the select FinancialStatements.

Now the method looks like

finStmtList = selectFinancialStatements(ValueObject, shortFormat, latestOnly, true);

Is this fix will result in any performance gain?

[635 byte] By [urssireesha] at [2007-11-27 11:30:40]
# 1

At least, theoretically, yes.

manuel.leiriaa at 2007-7-29 16:35:15 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

Can any one suggest me that the above RecordSet Object contains large number of records that counts up to 1000 rows and having 30 columns? I tested the application. But the performance varies from time to time.

Is there any other way to fine tune it?

urssireesha at 2007-7-29 16:35:15 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

can you please let me understand?

urssireesha at 2007-7-29 16:35:15 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...