On which condition the front end and back end of any project are based?
Question:
Answer:
The backend should focus on things that backends are good at. Oracle is a relational database and should be used as such. You store and retrieve data from it.
You should not use the backend to implement front end functionality. So, for example, you shouldn't use Oracle to format strings for localization purposes; this is front-end functionality and something that VB has functionality to support.
Similarly, the frontend should not do processing that the backend is designed to do. Pulling over the rows from two different tables into VB and then trying to find the rows that match between them is a waste of resources (network, memory, developer time) whereas a simple JOIN in your backend would yield the results much faster.
So the condition is that each layer of the application has its "contract" or "responsibilities" and that no other layer should impose on that responsibility space.
More Questions & Answers...