Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How much can a database bare?

 
Ramakrishna Nalla
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi...all
I am working with a web based application and iam using jsp along with mysql, my project includes displaying of information retrived from database...

My doubt is:
Will it effect the performance of server... if i retrive large amount of data from the data base. Or should i consider storing my data in flat files..as there is not much quering need to be done on my data.

Thanks in Advance...
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think its fine to use Database. Just tune your database for reading stuff.

- Make indexes where needed.
- Dont pull out all the records in one shot, consider pagination instead.
- Tune your SQL queries.


- For code clarity and reusablity apply MVC Model 2 architecture.
- Database access code must be out of your JSP/Servlet.

Cheers.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!