var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Stored Procedure Waitfor command question
The following code does work but when the stored procedure is called it takes about 10 seconds for it to load. I am not refering to the 30 minute wait before the name is deleted.
Anyone have any ideas why the call would be so slow? Thanks.
conPubs = (New SqlConnection("Server=blah blah blah")
cmdCommand = New SqlCommand("DeleteName", conPubs)
cmdCommand.CommandType = CommandType.StoredProcedure
cmdCommand.Parameters.Item(0).Value = Name
@Name varchar (30)
Set NoCount On
WaitFor Delay "00:30:00"
Delete From NameTable Where Name = @Name
Does this occur when you use an oledb connection (not the sqlconnection) ?
Both! I was using SQL. I tried OLEDB and it's a lot faster but still not fast enough to be practical. Takes about 10 seconds to queue it.