View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Performance Issue on generating and deleting periodic meetings - ProjeQtOr
 
 

Performance Issue on generating and deleting periodic meetings

More
08 Jun 2017 16:06 #1 by #Chris
Hello all,

when we use periodic meetings I we ran in a performance issue:

Generating a periodic meetings with 200 entries takes on our server about 10 min.
Deleting the complete periodic meeting took about 8 hours.

To check if it is an issue on our server side I tried on your demo server and it represents the same issue:

Generating takes about 2 min.
Deleting takes 1:30 hours

So your demo server is about 5 times faster, but the issue is repoduceable.

I also checked the number of queries on the sql server and on our side there where about 50Mio. queries, only due to deleting.
Is there any way to improve the performance ?

Thank you.

#Chris

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

More
11 Jun 2017 18:23 #2 by babynus
2mn for generating 200 entries does not frighten me.
It is more an issue with 1h30mn to delete the 200 entries, but could be understood as many controls are executed before deletion.
We'll have a look at possible performance improvement...

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: #Chris

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

Moderators: babynusprotion
Time to create page: 0.025 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.