Re: attached libraries in Forms4.5 vs. database procedures

In article <4hmjql$kls_at_hubcap.clemson.edu>, Janice Powell (powell_at_clemson.edu) says...
!
!We are in the process of setting up some libraries in Forms 4.5; we
!plan to have our applications attach to these libraries. Is there any
!benefit in storing our procedures/functions in the database rather than
!in a library that has to be attached to the forms?
!
!Any info would be greatly appreciated.
!
!Please send replies to this newgroup and/or my e-mail address
!(powell_at_clemson.edu).
!
!
!Thanks.
!--JP
!Janice Powell
!Programmer Analyst
!Clemson Univ.
!Clemson, SC

Of course, of course:
Whenever a procedure needs data from the database, this involves network (slow) traffic. In client/server, if you want anything approaching 'performance', you have to reduce network traffic to the barest necessities.
Store runtime and forms on the client, create views on the server to avoid post-query triggers, in parent-child queries, let the parent indicate if there are any children, ...
Performance on a client/server has got nothing to do with the power of the client involved, but that was not your question.

Kind reGards

     \ /   |
      X    |
     / \   s
     Gerard