View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Low speed when loading. - ProjeQtOr
 
 

Low speed when loading.

More
10 Jul 2017 07:33 #1 by vanlele
Hi,

My projeqtor is running on local Xampp.

The total activities we created is about 9,000 item. And i see the sofware start to run low.

It need 15 seconds to load info of activities when i click, the same for other request.

My server PC i is core i5, ram 16Gb.

Can you tell me why it too low speed please, how to speed up?

Thanks.

Please Log in or Create an account to join the conversation.

More
10 Jul 2017 08:52 #2 by babynus
Replied by babynus on topic Low speed when loading.
Difficult to investigate with so little information.

First, whan you say "access to activities" do you mean get the list or get the detail of one activity ?

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
10 Jul 2017 09:17 #3 by vanlele
Replied by vanlele on topic Low speed when loading.
The same for listing activities and show info.

Even when i update activites info, it need about 8 seconds.

Thanks.

Please Log in or Create an account to join the conversation.

More
10 Jul 2017 20:29 #4 by babynus
Replied by babynus on topic Low speed when loading.
I can confirm this is not normal.
For instance you can test perfs.projeqtor.org, with about 10000 activities.
Listing all activities is less than 3 seconds.
Getting detail for 1 activity is abot 1 second.

Check log file for errors of too verbuous logging.
You can possibly check log files for mysql and activite the "long query logging" to check which queries are long.
Check your CPU, and HDD accees.
Maybe it's just configuration of mysql allowing too small cache...
It's difficult to help more without investigating on the machine.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
11 Jul 2017 04:06 #5 by vanlele
Replied by vanlele on topic Low speed when loading.
I have found a lot long query like this:

2017-07-11 08:25:40.642
DEBUG
5.208813;select * from history where (refType, refId) in ( ('x',0), ('Activity', 8855), ('ActivityPlanningElement', 9975)) order by operationDate desc, id asc

Can you help me to fix it please?

Please Log in or Create an account to join the conversation.

More
11 Jul 2017 06:50 - 11 Jul 2017 06:50 #6 by vanlele
Replied by vanlele on topic Low speed when loading.
Dear Babynus

In attachment is log file, its record only time for update name of activites.

To load activites info now its just take 4 seconds. Then i change name of activities and save, it took 50 seconds.

Please help.
Attachments:
Last edit: 11 Jul 2017 06:50 by vanlele.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.045 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.