Sure, The keys can help speed and many other things. But I've also noticed that people leave this stuff in the code to prevent others from figuring out how all the data ties together.
As for my personal opinion, yes, there should be relationships defined in the DB, it will make things faster and better organized, which won't do much for a small DB, but will work wonders for a large one. I've never seen a DBA argue for this, I'm very surprised by this. The DBA should be demanding keys and indexes. > -----Original Message----- > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 27, 2005 3:08 PM > To: CF-Community > Subject: Relations in the db > > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Save $10 Download ZoneAlarm Security Suite http://www.houseoffusion.com/banners/view.cfm?bannerid=66 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:166809 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