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

Forums | Webyog

Tools to manage and monitor MySQL databases

Slow Perfomance In Sql-script

This topic is empty.

Viewing 2 reply threads

Author

Posts
- 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 2 reply threads

You must be logged in to reply to this topic.