TCpro verly slow - too many db queries?

If you need support with TeamCal Pro (installation, configuration, usage) post your request here.
Post Reply
mattbone
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 2011-10-24, 17:40

TCpro verly slow - too many db queries?

Post by mattbone » 2011-10-24, 14:01

Hello all,
I've setup a fresh installation of Teamcal Pro on a LAMP machine. I have 26 users. No other data has been entered yet.

I noticed that it takes almost 10 seconds to show one month of the calender!!

After a little digging I found that it takes over 4800 database queries to display one month of calender for those 26 users. That alone accounts for 4 seconds of processing.

I like Teamcal pro really much, but under these circumstances it is not usable.

The MySQL server in my setup is on another machine but even on the same machine it's not really that much faster.

Any suggestions are highly appreciated.

Thanks,
Matt

SIEMI
Fresh Boarder
Fresh Boarder
Posts: 10
Joined: 2009-12-22, 21:08

Re: TCpro verly slow - too many db queries?

Post by SIEMI » 2011-11-30, 13:30

Hi there,

i have the same problem. New DB without any large data cubes but TCPro is already slow.

Any suggestions??
Please!

Thanks in advance!
SIEMI

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

Re: TCpro verly slow - too many db queries?

Post by George » 2011-12-27, 16:25

Hi guys,
indeed is TCPRo rather built for smaller teams and the DB architecture is not optimal for large amount of users. I am already working on a completely revamped TCPro4 using a PHP/DB engine. However, since I can only work in my private time on this it is nothing that can be finished quickly.
Best regards,
George

Post Reply