• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

When return huge amount of data to java based application, What are the guild lines and strategy sho

 
sanjey asok
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When return huge amount of data to java based application,
What are the guild lines and strategy should be followed?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34974
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A few ideas:
1) Don't return any columns you don't need.
2) Return the data in batches. (Also consider what you are doing with the data and why you need so much. Unless you are downloading a huge report, you may need less data than you first think.)
3) Test the performance early to see how it meets your expectations.
 
sanjey asok
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Return the data in batches


Is very interesting please explain how it will be implemented
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34974
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You have a primary key for your table/data. Suppose it is a number. You could add a clause to say you only want records 1-1000, 1000-2000, etc. That way your code controls what data is returned.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic