Stored Procedure and views

Yii 1.1 General Discussion
1

Guys, I want to know your thoughts on stored procedure and view

Is there any use of mysql stored procedure and view with YII? I don’t think procedure and view is a good way to use with YII because YII is already providing the good relation data model.

What’s your thought on this?

Thanks and Regards,

2

There are still valid reasons to use views and stored procedures but

  • these reasons apply only (or mostly) to large and complex database shemas, especially when the schema isn’t under the control of application developers. In this case views and stored procedures are the “public API” of the database you can safely code against.

  • views and stored procedures provide very limited possibilities in MySQL (compared to some other vendors).

It’s always an application specific design decision.