DevForce Community Forum : Foreign Keys http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Foreign Keys Sat, 11 Apr 2026 09:56:07 -700 Thu, 19 May 2011 15:38:51 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2699 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Foreign Keys : Hi Paul, Declaring FKs in... http://www.ideablade.com/forum/forum_posts.asp?TID=2699&PID=10759#10759 Author: sbelini
Subject: 2699
Posted: 19-May-2011 at 3:38pm

Hi Paul,
 
Declaring FKs in the Object Mapper will not cause problems even if the FKs are not set in the DB. (In fact, if you don't create the FK for the association, it won't compile)
 
You mentioned you noticed performance decrease when querying.
What kind of query are you experiencing this performance decrease with?
How significant is the performance loss?
 
Silvio.


Edited by sbelini - 19-May-2011 at 4:05pm]]> Thu, 19 May 2011 15:38:51 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2699&PID=10759#10759 Foreign Keys : Does declaring foreign keys within... http://www.ideablade.com/forum/forum_posts.asp?TID=2699&PID=10729#10729 Author: tooms
Subject: 2699
Posted: 17-May-2011 at 3:26pm

Does declaring foreign keys within the Object Mapper that are not in the Database (SQL Server in this case) cause a problem?

We had previously NOT delcared foreign keys within our database, but we notice when we add them there is a significant decrease in the performance and IdeaBlade queries.
 
Cheers,
Paul Twomey
MEX
]]> Tue, 17 May 2011 15:26:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2699&PID=10729#10729