Re: pl/sql versus pro*c

In article <328C8E0E.8C8_at_turner.com>, Eric Friedman <eric.friedman_at_turner.com> writes
>Eric Mosley wrote:
>>
>> I know this is too generic for serious discussion (but who wants a serious
>> discussion on friday anyway)...
>> If you have a big unix rdbms system and it needs a lot of administrative
>> programs and functions etc,. should you do everything in pl/sql or use
>> reliable old pro*c? Is there a speed difference, what are the considerations?
>>
>> Eric.
>
>One advantage of PL/SQL is that it reduces the amount of network
>traffic; in pro*c, each sql statement needs to be sent to the database.
>
>One possible drawback is the proprietary nature of pl/sql; porting it to
>another RDMS is likely to be more difficult than in pro*c.
>
>Eric
PL/SQL has some arbitrary restrictions (like no tables/arrays of records)! If you can live with these then it is probably quicker to write (though for normal procedural operations is up to 50 times slower than C/C++).

-- 
Chris Dipple, Production DBA, Royal Bank of Scotland