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 electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by another person is strictly prohibited. If you are not the intended recipient of this e-mail, promptly delete it and all attachments. "Unmoderated discussion of advanced .NET topics." <[email protected]> wrote on 09/13/2005 01:30:21 PM: > It depends highly on where those making the decisions are coming from. > Programmers tend to favor n-teir approaches where tasks are divided into > buckets that preform their assigned role. DBAs tend to push as much as > possible into the database engine letting the rest of the app to handle the > interface. > > I am a programmer - thus I tend to find the idea of keeping business logic > in the primitive database languages available abhorrant. I like to keep the > ability to completely ripout the business logic if necessary have have it > affect the other parts as little as possible. > > =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
