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...
posted 10 years ago
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.