Client Side or Server Side?

To all,

A big issue lately at our site has been whether to place stored packages/procedures/functions on the client side or on the server side of the application.

We currently have a lot of code developed and stored on the server side. Some of these objects could be migrated into form libraries on the client to help performance and take some of the daytime load off the server, if necessary.

We're running Oracle 7.2 on Sequent/Dynix with Forms 4.5 on the client side. Most client PCs will have 16M of memory. The database contains approx 100 tables; the largest group of tables contain approx 15M rows.

Nearly every module contains at least one fetch from a database table; many are used to centralize updates/inserts for the application; we don't have any purely "calculation" programs that I know of.

Does anyone have guidelines/rules of thumb to follow in making this decision? Any examples of purely client side code? Any examples of purely server side code?

Thanks!

-- 


-------------------------------------

Warren Nisley - wnisley_at_ix.netcom.com


-------------------------------------