Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Java (http://www.velocityreviews.com/forums/f30-java.html)
-   -   Handling Large Resultset in Oracle (Scrollable Result Set) (http://www.velocityreviews.com/forums/t662900-handling-large-resultset-in-oracle-scrollable-result-set.html)

Tincy 01-13-2009 11:17 AM

Handling Large Resultset in Oracle (Scrollable Result Set)
 
Hi All, In my Application I am using OJB1.4 if I am doing some particular UI searches with pagination ,My memory usage is keep on increasing. how to reduce mem heap usage with Scrollable RS
It has been observed in UI searches on the particular pages,that the memory size can be made to increase by navigating the UI pages using Next, Last, Previous page navigation buttons.

Please suggest a solution or how to resolve the mem size increase problem with UI Search button.
When the UI Search button is used, the system creates a ScrollableResultSet. How can we stop the mem size from increasing
indefinitely with ScrollableResultSet.
Do we know how to solve this memory issue when executing large
resultset in Oracle.


All times are GMT. The time now is 11:49 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.