Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Performance Issue o...
 
Notifications
Clear all

Performance Issue on generating and deleting periodic meetings

2 Posts
2 Users
0 Reactions
2,720 Views
(@chris_1784997064)
Posts: 50
Active Member
Topic starter
 
[#4406]

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


 
Posted : 08 Jun 2017 18H06
(@babynus)
Posts: 14952
Member Admin
 

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...


 
Posted : 11 Jun 2017 20H23
Share:

Scroll to Top