Board index » delphi » RI Question: Declarative vs Trigger
Isaac Alexander
Delphi Developer |
Isaac Alexander
Delphi Developer |
RI Question: Declarative vs Trigger2006-12-12 08:43:51 AM delphi183 I am using SQL Server 7, 2000 and 2005. All of my cascading RI is handled via triggers (generated by data modeller). From a performance point of view (100 million plus recs in a table), is it better to use declarative RI or trigger RI? The reason I ask is because I currently still support SQL 7 and I'd like to avoid separate app versions of the database per SQL Server version. |
Dan Palley
Delphi Developer |
2006-12-12 08:51:34 AM
Re:RI Question: Declarative vs Trigger
"Isaac Alexander" <XXXX@XXXXX.COM>writes
QuoteI am using SQL Server 7, 2000 and 2005. SQL Server, though. Dan |
Oliver Townshend
Delphi Developer |
2006-12-12 10:07:15 AM
Re:RI Question: Declarative vs TriggerQuoteFrom a performance point of view (100 million plus recs in a table), is it to code a trigger to affect locks etc. a lot less than declarative RI would. If your declarative RI is simple, I would stick with that. If it needs to be specialized, triggers will be better. Oliver Townshend |
Isaac Alexander
Delphi Developer |
2006-12-13 12:41:00 AM
Re:RI Question: Declarative vs Trigger
"Oliver Townshend" <oliveratzipdotcomdotau>writes
Quote>From a performance point of view (100 million plus recs in a table), is |
Dan Palley
Delphi Developer |
2007-03-21 03:26:02 AM
Re:RI Question: Declarative vs Trigger
"Andrew V. Fionik" <XXXX@XXXXX.COM>writes
QuoteHello, Isaac! www.cvalde.net/document/declaRefIntegVsTrig.htm Dan |