View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Low speed when loading. - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Low speed when loading.

More
10 Juil 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 Connexion or Create an account to join the conversation.

More
10 Juil 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 Connexion or Create an account to join the conversation.

More
10 Juil 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 Connexion or Create an account to join the conversation.

More
10 Juil 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 Connexion or Create an account to join the conversation.

More
11 Juil 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 Connexion or Create an account to join the conversation.

More
11 Juil 2017 06:50 - 11 Juil 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 Juil 2017 06:50 by vanlele.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.055 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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