Using 'With Nolock' in Crystal Reports

[krshtej]

Hi,

I have a general question. When we see the code behind in crystal reports it is not showing any 'With (NOLOCK)' for the tables. Wont this result in dead lock situation or performance issues?
Is there a way to insert that 'With (NOLOCK)' while designing a report. (General designing not using Add Command).

Thanks,
Krshtej.

 

[RTag]

You can use command or stored proceduretp retrieve the data and use WITH NOLOCK.

http://www.R-Tag.com

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

 

[Turkbear]

The way Crystal interacts with your database is controlled by the database..Since you are not updating the data just retrieving it, it should never cause a deadlock (unless your database is badly designed or configured)
Most modern database engines provide retrieval of a version of the data as it existed at the moment the connection was made.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[RTag]

I totally missed the part for the deadlocks.
"WITH NOLOCK" will allow you to read uncommitted data. Your report may be ready faster but it may contain dirty data. Are you sure you want this ?

http://www.R-Tag.com

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

 

[krshtej]

Hi RTag,

Actually in my company they are using in that way (WITH (NOLOCK)) to retrieve the data fast. So, just to go with the company we have to do that. Thanks for the help though!

--Krshtej.

 

[krshtej]

Thanks Tuckbear that information is helpful.