> If I create a relational DB structure but do not define the
> relationship at the database level, is there a loss in performance
> when my application requests data from two tables based on the
> relationship. I guess what I'm asking is do you need to define
> the relationship at the DB level?
You won't necessarily lose performance, but you still want to declare the
relationship in the DB. That's what the DB is for! Imagine that you treat
two tables as related in your app, but they're not related in the DB, and in
one location in your app you forget to treat the two tables as related. That
won't be very good at all. Again, this is one of the reasons why we pay good
money for relational databases.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
