Unsupported Screen Size: The viewport size is too small for the theme to render properly.

insert/update mode very slow

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › insert/update mode very slow

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • September 21, 2003 at 5:06 pm #14927
      Ritesh
      Member

      Thats strange 😮

      Are you finding SQLyog sluggish in Insert/Update option or any other area?

      Are you scrolling using “SCROLLBARS” or “ARROW KEYS”?

    • September 22, 2003 at 6:58 am #14928
      Shadow
      Member

      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.

    • September 22, 2003 at 5:04 pm #14929
      Ritesh
      Member

      Shadow,

      I think this is a wrong statement.

      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 🙂

    • September 24, 2003 at 6:44 am #14930
      Shadow
      Member

      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!

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.