B*****g 发帖数: 34098 | 1 【 以下文字转载自 Java 讨论区 】
发信人: goodbug (好虫), 信区: Java
标 题: Re: Job with Oracle PL?
发信站: BBS 未名空间站 (Mon Dec 19 14:41:39 2011, 美东)
This is true and false, while stored procedure doesn't need to move
data around, the computation power on the DB server is relatively
weak, hard to scale, and expensive for every CPU added. Not to mention,
PL/SQL SP is hard to maintain.
So while there's certain area stored procedure can be useful (like report)
but the trend is moving out of it. People are using ORM to replace SP,
Hadoop to speed up processing in a cluster, NoSQL DB to replace relational
DB for lower cost and higher throughput. Even Oralce now has API to
write stored procedure in Java rather thant PL/SQL.
At the end of the data, PL/SQL is bad in 3 areas.
1. Oracle is expensive and cluster Oracle is even more expensive
2. PL/SQL is meant to run on single machine, scalability is a suspect.
3. PL/SQL is hard to maintain. |
|