New Posts New Posts RSS Feed: Foreign Keys
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Foreign Keys
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
tooms View Drop Down
Newbie
Newbie
Avatar

Joined: 17-May-2011
Location: Brisbane
Posts: 4 		Post Options Post Options   Quote tooms Quote  Post ReplyReply Direct Link To This Post Topic: Foreign Keys
    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
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 786 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down