Sadly almost all of our projects here are done this way with the exception of they rely on CFM instead of VB. The project I am trying to finish up right now I put the ref. int. checking in the database and to help sell the idea I made a custom tag and stored procedure that makes it a no brainer on displaying any violations to the user. That in turn means less coding for any future projects so hopefully they buy into the idea. As far as the database being quicker, I am no expert on that but from what I remember when I was reading on this it actually makes it a tad slower since it has to do the check but I think that example was specific to Oracle and no telling if it was correct or not. The only selling points I can think of to do it in the database is that anything that interacts with the database has to enforce those rules. Things that could interact may not be a program but could be an individual trying to manually insert things. Individuals, other developers, inserting things manually is what has bitten us hard in the past.
On 7/27/05, Marlon Moyer <[EMAIL PROTECTED]> wrote: > > I've just recently noticed that one of our databases in sqlserver has > no relationships defined. I talked with the 'dba' about this and he > told me that all of that logic is contained in the VB app that updates > the data. I'm not saying that there aren't any foreign keys defined, > just that he's not specified that relationship inside of the db. So I > talked with my supervisor and he wanted some examples of why we should > move the logic out of VB and into the database. > > Aside from the obvious reason of keeping the db logic inside of the db > and built in referential integrity, I was stumped. I thought given > the relationships, sqlserver gets hints as to how to speed up joins > and such. I've already suggested that different programs that use the > data wouldn't have to recreate the integrity logic, but I need > more.........or maybe I don't. Maybe it's fine to keep this in VB? > > > -- > Marlon > > "I don't believe in heaven or hell, no saints, no sinners, no devil as > well, no pearly gates, no thorny crown, you're always looking us > humans down" > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:166795 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54