Cascading delete performance

14 Feb 2006 6:36 PM

Rolf

Hi

I need to implement cascading delete between related tables. I can do
this in sql server (2005) or in the dataset in my application. But what
is the best solution when perfermance is important ?

Thanks

Rolf

14 Feb 2006 7:32 PM

W.G. Ryan - MVP

Ultimately you'll need it done in both places won't you? If not then you'll
be dealing with data that isn't snychronized.
Show quote

"Rolf" <rolf-***@online.no> wrote in message
news:1139942169.789386.213420@g44g2000cwa.googlegroups.com...
> Hi
>
> I need to implement cascading delete between related tables. I can do
> this in sql server (2005) or in the dataset in my application. But what
> is the best solution when perfermance is important ?
>
> Thanks
>
> Rolf
>

14 Feb 2006 8:44 PM

Miha Markic [MVP C#]

I would say database.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"Rolf" <rolf-***@online.no> wrote in message
news:1139942169.789386.213420@g44g2000cwa.googlegroups.com...
> Hi
>
> I need to implement cascading delete between related tables. I can do
> this in sql server (2005) or in the dataset in my application. But what
> is the best solution when perfermance is important ?
>
> Thanks
>
> Rolf
>

15 Feb 2006 3:33 AM

Darren Kopp

Deleting in the database will have the best performance, and will
handle data integrity the best.

To solve syncronization, just refill the dataset.

HTH,
Darren Kopp
http://blog.secudocs.com/