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 4 reply threads
  • Author
    Posts
    • September 19, 2003 at 8:45 pm #8172
      jacdx
      Member

      We're using P4-2.4Ghz Compaq EVOs (I know, they suck) running NT4.0 SP6 (I know, it sucks). We've been evaluating different admin tools

      (MySQL Manager, Navicat, Mascon, SQLyog). So far, Mascon and SQLyog are neck and neck at the price/performance point we need.

      SQLyog would take the cake, but the performance of the insert/update mode is very slow on these machines, and it's something we use all of the time in Mascon. It's slow to scroll, slow to move the cursor around, etc. It doesn't matter if there are 10 rows or 1000.

      I did notice that SQLyog is hitting the harddrive everytime I move the cursor or scroll, which doesn't help. But why would it be? There's plenty of non-virtual RAM

      available. And Mascon's grid editor performance is lightning fast in the same circumstances (on the same database/tables)

      I haven't tried SQLyog on any other machine or OS to know if it's either of those. But changing either of those is out of our hands.

      Any ideas? 😕

      Thanks.

      Jacob Hanson

    • 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 4 reply threads
  • You must be logged in to reply to this topic.