Today, I did an UPDATE statement on SQL Server Management Studio on a few
Now, from a VB.NET program when I tried to get those records that I updated,
when I go thru the datareader, when it gets around those records that I
updated, it timed out.
Even though getting the same query thru SQL Server Management Studio is very
What can I do to fix it ?
This is the UPDATE statement that I did
UPDATE tickdata1min set openprice = openprice *10,highprice = highprice *10,
lowprice = lowprice *10,closeprice = closeprice *10 where symbol = 'YMM0'
AND SEQUENCENUMBER >= '20100511-0950'
AND SEQUENCENUMBER <= '20100511-1038' AND CLOSEPRICE < 100
This is the Stored Procedure that I use
exec GetData1Min @Symbol='YMM0',@SeqNumLow='20100511-1000'
Using command = New SqlCommand(sql, connection)
Dim reader As SqlDataReader
outputData = ""
currentSequenceNumber = reader(0) -> timed out when it gets to
SEQUENCENUMBER >= '20100511-0844'
If I do
exec GetData1Min @Symbol='YMM0',@SeqNumLow='20100511-1040', it won't timed
If I do GetData1Min for other symbols that I didn't update today, it won't
It only timed out on the symbols that I did an "UPDATE" statement thru SQL
Server Management Studio.