Why are MySQL Routines and Views not used with PHP?

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.

View Answers

November 14, 2013 at 4:25 PM

Hi,

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.

Thanks


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?

Ads









Related Tutorials/Questions & Answers:
Why are MySQL Routines and Views not used with PHP?
why get method is used?
Advertisements
Why bufferedreader is used in java?
Why XML?, Why XML is used for?
Why C++ is not used in machine learning?
ModuleNotFoundError: No module named 'phpy'
ModuleNotFoundError: No module named 'routines'
ModuleNotFoundError: No module named 'csound-routines'
ModuleNotFoundError: No module named 'csound-routines'
ModuleNotFoundError: No module named 'print-fortran-routines'
Import MYSQL file in PHP - PHP
MySQL Not Records
Mysql As
Mysql Check
MySQL
Mysql Insert
Why NSMutableDictionary
Why request.getParameter(
Mysql PHP Select
Mysql Last
MYSQL
Creating Views
mysql
Why spring?
Mysql Decimal Datatype
ModuleNotFoundError: No module named 'views'
ModuleNotFoundError: No module named 'views'
mysql
Mysql Multiply
Mysql Describe
Mysql Multiply

Ads