Sqlyog 5.12: Very Slow Update Time

This topic is empty.

Viewing 12 reply threads

Author

Posts
- May 19, 2006 at 9:10 am #9692
  
  dany
  Member
  
  I've installed SQLyog 5.12 and I've found a bad surprise:
  
  when you modify a row of a table and press and arrow key (up or down) it takes 5 (FIVE) seconds to change row.
  
  I've tested SQLyog on a local server (same computer).
  
  Tested on Windows 2000 AND on Windows XP.
  
  SQLyog 4.1, for example, takes a lot less than a second.
  
  Bye,
  
  Daniele
- May 19, 2006 at 10:17 am #21662
  
  Ritesh
  Member
  
  This is strange.
  
  In v5.1 and ahead, we do extra checking for values like TIMESTAMP, CURRENT_TIMESTAMP etc. which requires extra processing but it should not make it 5 times as is your case.
  
  How many columns you have in your table?
- May 19, 2006 at 10:34 am #21663
  
  dany
  Member
  
  This table comes from a MySQL 5.0.21 server.
  
  Similar problem on a similar table in a MySQL 4.1.x server.
  
  Here is the CREATE TABLE COMMAND:
  
  /*
  
  SQLyog Enterprise – MySQL GUI v5.12
  
  Host – 5.0.21-community-nt : Database – aaa
  
  *********************************************************************
  
  Server version : 5.0.21-community-nt
  
  */
  
  SET NAMES utf8;
  
  SET SQL_MODE='';
  
  create database if not exists `aaa`;
  
  USE `aaa`;
  
  DROP TABLE IF EXISTS `test`;
  
  CREATE TABLE `test` (
  
  `id` int(11) NOT NULL auto_increment,
  
  `codice` char(5) NOT NULL,
  
  `a2` char(25) NOT NULL,
  
  `a3` char(100) NOT NULL,
  
  `a4` decimal(6,2) NOT NULL default '0.00',
  
  `a5` int(11) NOT NULL default '0',
  
  `a6` int(11) NOT NULL default '0',
  
  `a7` int(11) NOT NULL default '0',
  
  PRIMARY KEY (`id`),
  
  UNIQUE KEY `indexCodice` (`codice`)
  
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
- May 19, 2006 at 11:43 am #21664
  
  peterlaursen
  Participant
  
  Here it takes around 1.5 seconds with that table,
  
  that is still to much ….
  
  That must be debugged where the time goes …
- May 19, 2006 at 11:43 am #21665
  
  Ritesh
  Member
  
  Something that needs to be worked upon. We have started working on v5.13 and I have put this issue in the TO-DO list of v5.13.
- May 19, 2006 at 12:57 pm #21666
  
  peterlaursen
  Participant
  
  This is a DATA tab issue. From RESULT tab it is lightning fast. Also with tables having around 50 columns or more. So it is not the KEYWORDS check, but the responsivity of DATA tab as such that is the issue.
- May 19, 2006 at 3:24 pm #21667
  
  peterlaursen
  Participant
  
  5.02 is fast too! And even 5.11 is.
- May 19, 2006 at 4:47 pm #21668
  
  Ritesh
  Member
  
  This gets even more strange as we have not changed anything between 5.11 and 5.12 regarding data tab but I will take a look anyway tomorrow.
- May 20, 2006 at 6:03 am #21669
  
  Manoj
  Member
  
  Hello,
  
  We are able to fix this problem in 5.13 development tree.
  
  Thanks for reporting…..
  
  Manoj
- May 23, 2006 at 11:46 am #21670
  
  peterlaursen
  Participant
  
  I cannot see any change from 5.12 to 5.13 beta.
- May 23, 2006 at 2:12 pm #21671
  
  Manoj
  Member
  
  peterlaursen wrote on May 23 2006, 11:46 AM:
  
  I cannot see any change from 5.12 to 5.13 beta.
  
  5.13 Beta 2 is released.
- May 23, 2006 at 2:33 pm #21672
  
  peterlaursen
  Participant
  
  Yes, that was better.
  
  Sorry for me confusing the different installers.
- June 13, 2006 at 12:07 pm #21673
  
  Ritesh
  Member
  
  Solved in 5.14
  
  http://www.webyog.com/forums/index.php?showtopic=2216
Author

Posts