+1 on the below. IMHO--the db data is usually the authoritative record of whatever it is your app is tracking--that's what gets restored if there's some cataclysmic event. So having bad data in the db is bad. ;-) Now, unless you can mandate (and enforce!) that the *only* way data pass in & out of the db is via your app, then it's best to protect the data where they live--on the db. And can you ever really enforce that? There's always going be someone who knows how to odbc-link tables in msaccess.
That's not to say that's the *only* place to put them--or that *every* rule should go there. But the more you have there, the better integrity you'll have. -----Original Message----- From: Unmoderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Flory Sent: Wednesday, September 14, 2005 4:53 AM To: [email protected] Subject: Re: [ADVANCED-DOTNET] Business logic > I wouldn't necessarily call database languages primitive. They are a > specialized tool for set based logic. Set based logic is something few > developers understand. How much extra unindexed data will you bring over > to the middle tier for processing? Also as far as change control goes it > is easier to make a backend change than any other tier. > > Some one else made a comment about the database not scaling very well. > Most of the poor performing databases I have seen were developer designed. > No clustered index (heap tables), no other supporting indexes, no RI, > cursors used instead of set based logic, multi-value fields, select * from, > returning scalar values repeated in recordsets and so on. I am also pretty > sure that 99% or more of the applications being written out there won't > even come close to using up database resources, even many of the poorly > written ones. > > So just because the only tool you can use is a hammer, that doesn't mean > you should be using it on screws.... > > (BTW I am not advocating putting all the BL in the database or middle tier) > > > > > Tim Flory > Sr Programmer Analyst > Phone: 216.464.2244 ext. 229 > www.medquist.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
