General question for the future
Bender |
|
---|---|
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
|