Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jannable
Starting Member
25 Posts |
 Posted - 2006-12-06 : 12:05:37
|
| This is a bit of a continuation from my previous post ([url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=75744[/url]). Since my question is veering more and more away from the original purpose of that topic, I thought it would be best to start a new one.My question now is whether my habit of trying to centralize logic is actually a detriment to the efficiency of the database. As you may have read, I have one main view that does a lot of the thinking. Much of the code in the application uses this view in different ways to compute the values that it needs. This allows me to develop quickly and make changes to the core computations without any hassle of changing it in a bunch of places. This has worked well for me in the world of application development; but I'm worried that this habit is affecting the performance of the database. Does anybody have any opinions about this?Here's a link to the view: [url]http://jannable.com/vwProject.zip[/url] |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Centralizing Logic