Tuesday, May 14, 2002 03:20 AM
I am using ResultSet.absolute(), but it is too expensive. It takes on average 500 milliseconds to go to position 200 for a ResultSet of 5000 records. Can anybody suggests a solution to improve the performance?
My design is a Stateful Session Bean call DAO, and the DAO perform the query. I am using Weblogic Server 6.1SP2 and Informix Server version 3.
Thanks in advance.
Re: ResultSet.absolute() is too expensive
Tuesday, May 14, 2002 05:38 AM