Hi...Can anyone help me with my question....
Ok... I have a SQL tranaction say T1 with default Isolation level.....
In that Transaction T1 ... I have say 5 insert statements inserting thousands of records into say tables TBL_1,TBL_2,TBL _3,TBL_4,TBL_5.
I have a seperate C# web page (method which has it's own transaction)... which tries to insert records into say TBL_3 when the
transaction T1 is running.......
vjamalpur
Last Activity: Sep 3 '10, 05:20 AM
Joined: Aug 19 '10
Location:
-
SQL Transaction... Blocking inserts....
-
Thanks for the advice...
I'm connect to my company's network using VPN....
then I connect to my Database Server to open the Management Studio...and run the query that I gave...
My understanding is that the above setup should not be an issue... there should be smth else ? -
Ran it multiple times but did not reduce the execution time drastically... I only could get it down to 6 secs....
I even created a Stored Procedure (for execution plan sake)... and executed the stored procedure multiple times... even then the execution time stayed at 6 secs....
Thanks for your insights...Leave a comment:
-
SQL Server WHILE vs C# WHILE
I was running a small test on how WHILE loop fucntions.
this is a simple SQL code that I ran
declare @COUNTER int
set @COUNTER = 1
while @COUNTER <= 100000
begin
select @COUNTER = @COUNTER + 1
end
It took 7 seconds to run
I ran the C# equivalent which did not even take a second (fraction of second)
int counter = 1;
while (counter<=...
No activity results to display
Leave a comment: