The performance tuning is not just that.

tongcd (programmer)
For example, you have to update 1000 record at same time. By sql script, there would be 1000 thousand round trip between database server and your application, but by PL/SQL, it will be done in one trip. Besides, PL/SQL can be pre-compiled.
Yes, stored procedure is not always a good choice. Because that means build the business logic in the database, which means it is poor extensibility and maintainability. This is a trade-off.
(#836467@0)
2002-11-4 -04:00

回到话题: 再问个SQL问题(发现原来不好好学习,现在问题越来越多)

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=836467