Win a copy of Design for the Mind this week in the Design 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic