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.

Ticket entry extrem...
 
Notifications
Clear all

Ticket entry extremly slow with database growth

3 Posts
2 Users
0 Reactions
1,592 Views
(@divyesh)
Posts: 30
Active Member
Topic starter
 
[#7064]

For demo website and our test machine with few records ticket entry has no issues[as fast as your demo website].
As our ticket table from live database is only containing 52000 rows still user ticket creation and updation [status change of tickets] has become very slow.
There are wait events also recorded in logs.
We are using PostgreSQL 13.1 764 bit currently.
Request you to please review ticket specific application code to override this issue.


 
Posted : 24 Nov 2020 11H25
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Request you to please review ticket specific application code to override this issue.

Request you to please review your server configuration B)


 
Posted : 25 Nov 2020 17H10
(@divyesh)
Posts: 30
Active Member
Topic starter
 

Server configuration is 16gb ram with 4 CPU having 8 cores.
Just to brief the issue ,earlier we were using mysql with lampp and having same slowness issue.
After switch to Postgressql13 with latest Projeqtor version 8.6.5 in centos 8 with apache & php the issue still persist.
No other performance issue apart from Ticket slow insert and slow status change.
Will try to drill down the issue and possibly post the solution in tips and tricks section .


 
Posted : 26 Nov 2020 19H46
Share:

Scroll to Top