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

[Quoted] JAMES FRANCIS DAVIS wrote:

> 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>

You'll likely not find documentation as every installation and application is different.

I would suggest you run a few benchmarks.

But I'd rather have my code in the back-end even if everything else is equal. Makes maintenance a lot easier.

Dan Morgan Received on Wed Dec 04 2002 - 00:11:38 CET