Reason for SQLyog hitting the HD in the update window is that it keeps issuing UPDATE commands even if nothing was changed but you moved the cursor from one field to the other…
It's by design and I keep complaining about it. I have been promised that it's going to be changed in SQLyog Max.
SQLyog updates ALL columns for a row if ANY column in that row has been edited – but it does NOT update any rows when you are just scrolling. Pls. check out the history tab to confirm.
Future versions of SQLyog would only update changed columns 🙂
You got it wrong Ritesh! I didn't say SQLyog issued UPDATE statements when you scroll the window. But it does issue an UPDATE statement if you move the cursor into a field then move the focus without changing anything. I did check out the history tab!