Stored Procedure - Advantage of Stored Procedure - Disadvantage of Stored Procedure

Advantage of  Stored Procedure

• Stored procedures can be used to maintain data integrity and enforce database policy without relying on an external program to do so.
• the DBA can add behavior that the application doesn't care about. For example, storing a modify date on each row.
• You do not need to deploy to make a change.
• Much faster than dynamic queries
• Easier to expand a system
• A small functionalists can be added in SP (Store Procedure)

Dis-Advantage of  Stored Procedure

• Debugging is hard.
• Source control can be a pain.
• If you have a lot of functionality in store procedure it will making swapping between different database systems harder - It also creates more work if you want to support different database systems.
• Developing stored procedures can be a fairly specialized task, especially as they get more complex.
• Refactoring is harder. Renaming or changing where the store proc is might produce a bad effect.

Difference Between Cakephp and Zend Framework

S.No	Cakephp	Zend Framewok
1	It is just framework.	It is Both framework and library.
2	In View Form helper, there is form elements, validation available.	In View Form helper, there is form elements, validation, filters(like strip_tags), order of elements, sub form, and decoraters are available.
3	we can render form elements one by one	We can render form in one line, one by one element, element OR  decorator OR error separetly.
4	Form configuration can not done by through configuation file	Zend_form can be do configuration through zend_cofig or xml
5	When cake start, It load all library that's why Its not good for small project.	Its library is too big as compare to cakephp. If you are  not using any component then it will not load by default.
6	It uses front controller design and singleton design pattern.	It use front controller pattern, factory patter, strategy pattern, singleton pattern.
7	It is good for fast development.	It is best, if you application are using webservices
8	ACL, Auth like comonents are easily availbele for cakephp.	It has its own ACL, Auth components and upto deeper level.
9	When cake start, It load all library that's why Its not good for small project.	Its library is too big as compare to cakephp. If you are  not using any component then it will not load by default.
10	It have session component	It have Zend Session and Zend Registery components.
11	Its class name does not map with file location	Its mapping, If any class name is Zend_forms_abc file location is Zend/Forms/abc.php
12	Mostly used for fast development.	Mostly used for web services