Форумы / Cotonti / General / How about Mysql, Stored procedures and Views?

General question for the future

Bender
#33994 16.04.2012 14:07

Different benefits but a few points i have in mind

- security layer : different access for webserver and developer

webserver has only access to the db with sp/views while the developer has access to the 2nd db with real cms tables when needed

- easier cms-development/bugfix , change the sp/views in a central place instead hundred files

- less traffic : complex queries are shortened to a minimum ( eg joins, select 1,2,3...-n from and so on )

- less cms-sourcecode

- can reduce the amount of queries in total ( how many queries do the same thing where just the colums/tables are different )

- logging/errorlog/exceptions inside mysql sp's

- more security in general

 

or maybe just because its 2012 and not 19xx

Just a point of view

 

Bender