Re: Performance of Forms PL/SQL vs Database PL/SQL

I'm looking for some kind of documentation on this. In our case, the application server is just as powerful as the DB server.In article <3DECDFAB.F56F1482_at_exesolutions.com>, damorgan <damorgan_at_exesolutions.com> says...>JAMES FRANCIS DAVIS wrote:>>> If we have large PL/SQL functions, is it better to run them in Forms on the application server, or imbed it in the database and call it from the form? I remember when IAS 8i and 9iAS came out, there were some articles on this, but I that was a while ago. If anyone knows where whitepapers, presentations, etc exist on this subject, I would appreciate it.>>Always better to put code into the back-end database when possible.>>If nothing else it makes the forms leaner and faster loading. In almost all cases it makes the application run more quickly as the back-end server is the stronger piece of hardware and, if the code is used by multiple users, will most likely be in the cache when needed.>>Daniel Morgan> Received on Tue Dec 03 2002 - 21:00:18 CET