I have an e-mail table which has reached around 90,000 records. This is running on MSSQL server, and has a size of 1.5GB.
A script is hanging, and after a lot of response.write / response.flush statements through the ASP document, I have isolated the exact line which it is timing out on.
UPDATE EMails SET eProcessedDate = '2013-09-09 14:58:53', eProcessedBy = 0, eAutoIndex = 1, eStatus = 2 , eContract = 122 WHERE eId = 89611
eProcessedDate is a datetime field
All the others are integers
I can't work out why such a simple statement would hang.
Can anyone advise steps to optimise the table, or to diagnose why it is hanging?