v3.5.8 - Application queries slow - fix
Posted: Sat Jun 28, 2008 10:14 am
There is a known issue of slowness for any Application reports in 3.5.8. Version 3.5.9 Will be released with this and some other minor fixes this week between 06/30/2008 and 07/01/2008
In the meantime please run the following steps from the command line as this will dramatically speed up Application queries.
Type
C:\>mysql -udigitoll -pideadata
Result
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1343
Server version: 5.0.37-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Type
mysql> use DigiToll;
Result
Database changed
Copy Paste into “mysql>”
Drop View if exists ViewPort;
Drop table if exists ViewPort;
Create Table ViewPort
(
PortNumber int,
PortNumName varchar(100),
primary key (PortNumber)
);
Insert into ViewPort
Select Portnumber, concat('(',PortNumber,')',' ',Description) From Port
Where PortNumber>=0 Order by PortNumber;
Type
mysql> exit
In the meantime please run the following steps from the command line as this will dramatically speed up Application queries.
Type
C:\>mysql -udigitoll -pideadata
Result
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1343
Server version: 5.0.37-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Type
mysql> use DigiToll;
Result
Database changed
Copy Paste into “mysql>”
Drop View if exists ViewPort;
Drop table if exists ViewPort;
Create Table ViewPort
(
PortNumber int,
PortNumName varchar(100),
primary key (PortNumber)
);
Insert into ViewPort
Select Portnumber, concat('(',PortNumber,')',' ',Description) From Port
Where PortNumber>=0 Order by PortNumber;
Type
mysql> exit