Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

My finder method returns a large number of rows. Is there anyway I can improve the performance by reducing the round trips to database?

April 26, 2017finder large method PERFORMANCE reducing returns round rows

0

Posted

My finder method returns a large number of rows. Is there anyway I can improve the performance by reducing the round trips to database?

1 Answer

0

Posted

Oracle JDBC driver has extensions that allows setting the number of rows to pre-fetch into the client while a result set is being populated during a query, reducing the number of round trips to the server. This can drastically improve performance of finder methods that returns large number of rows by reducing the number of round trips. You can specify the prefetch-size for your finder method in the orion-ejb-jar.xml as follows: For details, see the EJB Developer’s Guide.