3.1.006 - 3.3.001 upgrade issue

If you need support with TeamCal Pro (installation, configuration, usage) post your request here.
Post Reply
fRd-
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 2010-05-07, 17:26

3.1.006 - 3.3.001 upgrade issue

Post by fRd- » 2010-05-07, 13:33

Hello,

I am currently upgrading tcpro from 3.1.006 to 3.3.001 inside our company. The thing is it works but the load times of each page is extremely long (approx. 2mins for the calendar view).

Do u have any ideas what the issue could be? I overwrote all the files and did the database upgrades as described in the upgradeinfo [3.1.006] -> [3.2.000]

ALTER TABLE `my_tc_daynotes` ADD `region` VARCHAR( 40 ) NOT NULL DEFAULT 'default';
ALTER TABLE `my_tc_months` ADD `region` VARCHAR( 40 ) NOT NULL DEFAULT 'default';
ALTER TABLE `my_tc_groups` ADD `min_present` SMALLINT NOT NULL DEFAULT '1';
ALTER TABLE `my_tc_groups` ADD `max_absent` SMALLINT NOT NULL DEFAULT '1';

Kind Regards,

Fred

User avatar
George
Platinum Boarder
Platinum Boarder
Posts: 420
Joined: 2004-11-29, 21:20
Are you a spam bot?: No
Contact:

Re:3.1.006 - 3.3.001 upgrade issue

Post by George » 2010-05-08, 19:56

Hi Fred,

that is difficult to say. My approach would be to install a fresh new instance of 3.3.001 and then import one table at a time and see where it gets slow.

You can also try to optimize your table and some database maintence from within TeamCal Pro.

Best regards,
George
TeamCal Neo is free for private use but requires licensing for use in a commercial environment:
https://georgelewe.atlassian.net/wiki/s ... eo+License

rosique
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 2005-02-27, 13:47

Re:3.1.006 - 3.3.001 upgrade issue

Post by rosique » 2010-08-31, 17:15

I am having the same problem. I even tried to upgrade from 3.1.006 to 3.2.001 up to 3.3.003 and I get the same results. It takes four times longer to load any version from 3.2.001 and above.
I have created a new data base, restored the tables one at a time and changed my.cnf configuration file and it still takes four times longer.
I am attaching a screen shot from MySQL Administrator.
Thanks,
John Rosique

rosique
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 2005-02-27, 13:47

Re:3.1.006 - 3.3.001 upgrade issue

Post by rosique » 2010-08-31, 17:19

Here is the attachment. Image

rosique
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 2005-02-27, 13:47

Re:3.1.006 - 3.3.001 upgrade issue

Post by rosique » 2010-08-31, 17:34

Here is a closer view of the graph.

Thanks,

John Image

User avatar
George
Platinum Boarder
Platinum Boarder
Posts: 420
Joined: 2004-11-29, 21:20
Are you a spam bot?: No
Contact:

Re:3.1.006 - 3.3.001 upgrade issue

Post by George » 2010-08-31, 17:59

Thanks for the addl. info. I will have an eye on that in the next development circle.

Best regards,
George
TeamCal Neo is free for private use but requires licensing for use in a commercial environment:
https://georgelewe.atlassian.net/wiki/s ... eo+License

rosique
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 2005-02-27, 13:47

Re:3.1.006 - 3.3.001 upgrade issue

Post by rosique » 2010-08-31, 18:37

George,

Thank you for all of your time and effort in making this an excellent program.

Thanks,

John

Post Reply