This week's book giveaways are in the AI and JavaScript forums.
We're giving away four copies each of GANs in Action and WebAssembly in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of GANs in ActionE this week in the AI forum
or WebAssembly in Action in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

Java Is Fetching 10 rows Only

 
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
   I am working with JAXRS using JNDI lookup with weblogic.I configured the weblogic RowPrefetch Size=100 but it is fetching 10 rows and again 10 not 100 at a time.Due to this performance decreases.


DAO Code:



JNDI Lookup Code:



In Weblogic Console Following Settings has been done:

Enable the Row Prefetch Enabled check box  and put Row Prefetch Size=100

Connection Pooling Settings is:

Initial Capacity = 200 , Maximum Capacity = 1000 and Minimum Capacity = 100

Can anyone guide me how i can fetch 100 or 50 rows at a time.In spite of doing all the settings in weblogic it is fetching 10 rows only.

Thanks,
Prabhash
 
Rancher
Posts: 4450
47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How are you determining that it is fetching 10 rows at a time?
 
Prabhash Mishra
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
   using this loop

for(int i=0; i < traversalTimes.length ; i++){
           System.out.println("Traversal Times["+(i+1)+"]: "+traversalTimes[i]);
           System.out.println("Next Times["+(i+1)+"]: "+nextTimes[i]);
       }

At every 11th records it is consuming some time between 2-10 is taking 0 time after every 10th record it is consuming some miliseconds.

Thanks,
Prabhash
 
A lot of people cry when they cut onions. The trick is not to form an emotional bond. This tiny ad told me:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!