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

Slow Perfomance In Sql-script

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Slow Perfomance In Sql-script

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • November 28, 2006 at 10:41 am #10055
      webtask
      Member

      My sql-script creates 71 tables. SqlYog 5.17-5.19 executes this script in several seconds, but 5.20 spends more than 30 min to run the script. Remote connection to MySQL 4.1.7. Also this slow behaviour occures when I try to empty my database.

    • November 28, 2006 at 11:39 am #22999
      peterlaursen
      Participant

      1) the issue with 'empty database' is confirmed. It is related to 'autocomplete'. 'drop database' and 'truncate database' are not affected.

      We will release 5.21 beta1 with a fix for this in a few days.

      2) However we cannot reproduce the slow import.

      Can you tell what 'Remote connection' means? HTTP??

      If so that could depend on the server load then.

      Can you reproduce with both versions installed at the same time?

      (import with 5.19 … measure time .. drop database .. measure time)

    • November 28, 2006 at 4:51 pm #23000
      webtask
      Member
      peterlaursen wrote on Nov 28 2006, 11:39 AM:
      1) the issue with 'empty database' is confirmed. It is related to 'autocomplete'. 'drop database' and 'truncate database' are not affected.

      We will release 5.21 beta1 with a fix for this in a few days.

      2) However we cannot reproduce the slow import.

      Can you tell what 'Remote connection' means? HTTP??

      If so that could depend on the server load then.

      Can you reproduce with both versions installed at the same time?

      (import with 5.19 … measure time .. drop database .. measure time)

      I mean “running” sql-script, not “import”. My sql-script consists over 70 “create table” operators. SQLYog successfully connected to remote MySQL server (not to localhost). When I run script – SQLYog not freezes, but execution goes extremely slow.

    • November 29, 2006 at 5:36 am #23001
      peterlaursen
      Participant
      Quote:
      I mean “running” sql-script, not “import”.

      OK. Confirmed too.

      Give us a few hours to analyze and discuss please … 😮

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