Effects of using Transaction in SP on Performance?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Essa - 21 Mar 2005 17:17 GMT

Hi All;

I have a web application which is being used at large scale and there are
upto 10,000 entries per day. Currently, there is no Begin Tran/Commit
Tran/Rollback Tran and b/c of that we found some data corruption. Now, I
changed all the transactional Stored Procedure and used Transaction into
them. Now, I am thinking about the performance of the application when I used
Transaction into Stored Procedures which are being used by each user very
frequently. Transaction Lock the objects which might hurt the application
performance. Please, comments on it and should I use Transaction now or not?

Thanks.

Signature

Essa, M. Mughal
Software Developer
Canada

Reply to this Message

Adam Machanic - 21 Mar 2005 17:32 GMT

You should DEFINITELY use transactions. Performance penalty or not. There
is no choice here. Data integrity is, by far, the MOST IMPORTANT THING IN A
DATABASE. Sorry for the all caps, but I had to drive it home. Do not
sacrifice your data quality. Otherwise there is very little reason to even
be using a database.

Signature

Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--

> Hi All;
>
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Essa - 21 Mar 2005 23:10 GMT

Hi Adam;

Thanks for your strong recommendataion. I really appreciate your way of
conveying me the importance of Data. I have already changed all the
transactional stored procedure but I was just wondering so now I'll go live
with them and then see what happens. I hope nothing will happen but it will
increase data integrity.

Thanks

> You should DEFINITELY use transactions. Performance penalty or not. There
> is no choice here. Data integrity is, by far, the MOST IMPORTANT THING IN A
[quoted text clipped - 16 lines]
> >
> > Thanks.

Reply to this Message