The update statement is as follows.

UPDATE Content SET ContentType =5,CaseId ='',Title ='XYZ',EventDate ='1980-01-01 00:00:00',Location ='',Address ='',FileName ='',URL ='',IsArchived =0,Author ='Magnus Dowson',LastUpdate ='2013-04-11 16:49:16',AlertSent ='2013-01-15 17:12:04',Published ='2013-01-15 17:08:22',IsPublic =0,BannerCode ='',IsDraft =0,IsAlertSent =1,NominatingEntity ='President',JudiciaryID =0,CourtID =0,BirthPlace ='',BirthYear =0,OfficePhone ='',CourtAddress ='',CourtLink ='',AdditionalCourtInfo ='',NominatingPresident ='',IssueInNomination ='',CommissionDate ='1900-01-01 00:00:00',ContentSubType =0,InternalNote ='',Picture ='',FirstName ='',Name ='',Ranking =5 WHERE ID=307183;

By one row at a time I mean it only updates one row, as you can see it updates the table using the primary ID column.

On my development machine I have restored the backup for testing purposes. The first time I run the above update statement it takes around 40 seconds, but then if I run it again it is very fast.

I am trying to find out why it is so slow the first time I run it but not the second time.

Would anyone be able to please help me?

Thanks