Re: front-end vs back-end

In article <3ca1ou$52c_at_hermes.is.co.za> motto_at_sasun1 (*) writes:
>
>I think that employing triggers and stored procedures at the server side brings along a number of benefits, inter alia:
 [snip]
>5) use of shared-pool is optimised (one version of function is cached, instead of numbers of different SQL statements having same function coded by different developers

Have you heard about bug #242573 (fixed in 7.1.3), that the optimiser reparses every stored procedure call it receives, leading to performance degradation?

-- 
							Yoichi Tamura
							y-tamura_at_nri.co.jp