Why are MySQL Routines and Views not used with PHP?
I've been looking at a number of web sites, frameworks, and scripts written in PHP and noticed NONE of them make use of MySQL Views or Routines. Alarmingly very very few even use indices. I'm wondering if anyone else has noticed this and can shed some light on this phenomenon. To me it seems that with PHP there has been a great deal of dumbing down when it comes to "proper" database usage.
November 14, 2013 at 4:25 PM
View is stored as just a simple SQL in the database. When user calls a view from the program it reads the sql of the view and then executes the query. So, there is no performance gain in the application. It is similar to executing the query from your program.
If you use the view then you may have to write extra code and logic to pass the parameters to the view.
So, its better to just use SQL and execute from your program itself.
November 28, 2013 at 3:01 AM
Thank you for your thoughts, I agree in using views it's more of a do what makes sense for your application. Personally I prefer them for reporting more then anything else.
Have you any input on why indices and routines aren't used?
Related Tutorials/Questions & Answers: