[midPoint] History tab in GUI is insanely slow

[Richard Richter]

Hi 

I recently fixed the issue you mentioned, but I totally forgot it was about History tab during the process. It didn't click into place at all when I was reading your mail. I'm really sorry about it. 

I'm glad you figured it out eventually. 

Best regards 

Richard Richter 
midPoint developer 


From: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
To: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
Cc: "Alexandre Zia" <alexandre.zia at ifood.com.br> 
Sent: Friday, October 2, 2020 4:20:54 PM 
Subject: Re: [midPoint] History tab in GUI is insanely slow 

Regarding this, 
To help others that may find this message inthe future: 

Just found this issue: [ https://jira.evolveum.com/browse/MID-6232 | https://jira.evolveum.com/browse/MID-6232 ] 

Fixed by adding an index to database: 

CREATE INDEX iAuditEventRecordEStageTOid 
ON m_audit_event (eventStage, targetOid); 




On Thu, Oct 1, 2020 at 11:11 AM Alexandre Zia < [ mailto:alexandre.zia at ifood.com.br | alexandre.zia at ifood.com.br ] > wrote: 



We jumped from 3.9 to 4.1 (upgraded at once from 3.9 to 4.0, and from 4.0 to 4.1) 
So We didn't use 4.0. 
Since we went to 4.1 consulting history tab for users is insanely slow, take minutes and as midpoint GUI interface doesn't allow opening each item in a new tab (oh man that would be awesome ...) it's impossible to use history tab 

Using postgresql 12 

Anyone having the same issue? 
Is there something we can do to fix this? perhaps an index on the database? 

Thanks in advance 

-- 
[ https://www.ifood.com.br/ ] 
	
	


Alexandre R Zia 


	


Security 


	


	


	
[ https://www.ifood.com.br/ | www.ifood.com.br ] 

	[ https://www.facebook.com/iFood?fref=ts ] 
	[ https://twitter.com/iFood ] 
	[ https://www.instagram.com/iFoodBrasil/ ] 
	[ https://www.youtube.com/ifood ] 





-- 
[ https://www.ifood.com.br/ ] 
	
	


Alexandre R Zia 


	


Security 


	


	


	
[ https://www.ifood.com.br/ | www.ifood.com.br ] 

	[ https://www.facebook.com/iFood?fref=ts ] 
	[ https://twitter.com/iFood ] 
	[ https://www.instagram.com/iFoodBrasil/ ] 
	[ https://www.youtube.com/ifood ] 

_______________________________________________ 
midPoint mailing list 
midPoint at lists.evolveum.com 
https://lists.evolveum.com/mailman/listinfo/midpoint 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20201005/fde62035/attachment.htm>