We have a project which contains huge database in Oracle. The application is totally built in PL/SQL[using HTP package].
Now the client wants a lighter version of the application to be used offline.
As oracle lite is compatible with
Java.. we are developing one more application converting all Oracle procedures to
JSP pages.
We are writing queries in the scriplet tags in the JSP's itself. Is it a good idea??
Does implementing MVC architecture to this project take more time to fetch many records from the DB and traverse them over the model classes.Does that take more time against fetching records from DB using queries in scriplets in JSP.
If we need to follow some other architecture then which is better?? The queries will be returning some thousands of records as resultset.