Re: ProC vs PL/SQL

Vincent Joseph (vincent.joseph_at_usa.net) wrote:
: Is anyone familiar with a resource on the web that compares/describes
: the performance/advantages/disadvantagtes of PL/SQL code to ProC code ?
: If not, does anyone have any opinions for/against?
: Also are there any general cases where would it be advisable to use ProC
: over PL/SQL (or vice versa.)

We've found PL/SQL to be much, much less efficient than C for raw computation. OTOH, most of our performance issues involve SQL, not host languages, and there are advantages and disadvantages that don't have to do with performance. Our experience is that it is much easier to develop and maintain PL/SQL than Pro*C: the way in which SQL is embedded in PL/SQL is more straightforward than Pro*C, and the PL/SQL language neither encourages or requires the complicated constructs that C does.

We use PL/SQL when we can, and C (not necessarily Pro*C) when we need efficient computation or interaction with the host OS.

Cheers,

--
| Dave Schweisguth                     CuraGen Corp., Bioinformatics Dept. |
| dcs_at_proton.chem.yale.edu             New Haven, Connecticut              |
| http://proton.chem.yale.edu/~dcs/    My opinions are my own.             |
| For compliance with the NJ Right to Know Act: Contents partially unknown |