[Building Sakai] Query Fetch Size

[Paul Dagnall]

(Sakai 2.6.x) After much investigation, we are seeing a bottleneck 
getting result sets from Oracle to the business logic layer. In multiple 
tools we see longer page load times when there are greater amounts of 
records being returned.

We are investigating modifying the query fetch size or "prefetch". Our 
thinking is that if we can increase the number of rows physically 
retrieved from the database at one time by the JDBC driver, we may see a 
performance improvement.

Does anyone have experience with this?

Paul Dagnall
Web Developer
University of Dayton