ResultSet.absolute() is too expensive
1 posts in topic
Flat View  Flat View

Posted By:   Anonymous
Posted On:   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

Posted By:   Bozidar_Dangubic  
Posted On:   Tuesday, May 14, 2002 05:38 AM

try CachedRowSets. they are pretty fast in moving back and forth. see if that works for you.
About | Sitemap | Contact