<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hi<br></div><div><br data-mce-bogus="1"></div><div>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.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>I'm glad you figured it out eventually.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Best regards<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Richard Richter<br data-mce-bogus="1"></div><div>midPoint developer<br data-mce-bogus="1"></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>From: </b>"midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>To: </b>"midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>Cc: </b>"Alexandre Zia" <alexandre.zia@ifood.com.br><br><b>Sent: </b>Friday, October 2, 2020 4:20:54 PM<br><b>Subject: </b>Re: [midPoint] History tab in GUI is insanely slow<br></div><div><br></div><div data-marker="__QUOTED_TEXT__"><div dir="ltr"><div>Regarding this,<br></div><div>To help others that may find this message inthe future:<br></div><br><div>Just found this issue: <a href="https://jira.evolveum.com/browse/MID-6232" target="_blank" rel="nofollow noopener noreferrer">https://jira.evolveum.com/browse/MID-6232</a><br><br></div><div>Fixed by adding an index to database:<br><br>CREATE INDEX iAuditEventRecordEStageTOid<br> ON m_audit_event (eventStage, targetOid);</div><br><br><div><br> </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Oct 1, 2020 at 11:11 AM Alexandre Zia <<a href="mailto:alexandre.zia@ifood.com.br" target="_blank" rel="nofollow noopener noreferrer">alexandre.zia@ifood.com.br</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb( 204 , 204 , 204 );padding-left:1ex"><div dir="ltr"><div>We jumped from 3.9 to 4.1 (upgraded at once from 3.9 to 4.0, and from 4.0 to 4.1)<br></div><div>So We didn't use 4.0.<br></div><div>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</div><br><div>Using postgresql 12<br></div><br><div>Anyone having the same issue?</div><div>Is there something we can do to fix this? perhaps an index on the database?<br></div><div><div><br><div>Thanks in advance</div><br><div>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><table style="font-family:'arial' , sans-serif;font-style:normal;font-weight:400;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 );color:rgb( 0 , 0 , 0 );font-size:medium" width="450" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td rowspan="6" style="font-family:'arial' , sans-serif;margin:0px" width="105" valign="top" height="120" align="right"><a href="https://www.ifood.com.br/" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/iFood_assinatura3.gif" width="105" height="110"></a><br data-mce-bogus="1"></td><td style="font-family:'arial' , sans-serif;margin:0px" width="18"><br></td><td style="font-family:'arial' , sans-serif;margin:0px" height="22"><div style="line-height:18px;font-family:'montserrat' , 'trebuchet ms' , 'lucida grande' , 'lucida sans unicode' , 'lucida sans' , 'tahoma' , sans-serif;color:rgb( 85 , 85 , 85 )"><p style="margin:0px;line-height:18px"><span style="font-size:14px">Alexandre R Zia<br></span></p></div></td></tr><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="18"><br></td><td style="font-family:'arial' , sans-serif;margin:0px"><div style="font-size:12px;line-height:14px;font-family:'montserrat' , 'trebuchet ms' , 'lucida grande' , 'lucida sans unicode' , 'lucida sans' , 'tahoma' , sans-serif;color:rgb( 228 , 0 , 43 )"><p style="margin:0px;line-height:15px"><span style="line-height:15px"><b>Security</b></span></p></div></td></tr><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="18" height="10"><br></td><td style="font-family:'arial' , sans-serif;margin:0px" height="10"><br></td></tr><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="18"><br></td><td style="font-family:'arial' , sans-serif;margin:0px"><br></td></tr><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="18"><br></td><td style="font-family:'arial' , sans-serif;margin:0px"><div style="font-size:11px;line-height:16px;font-family:'montserrat' , 'trebuchet ms' , 'lucida grande' , 'lucida sans unicode' , 'lucida sans' , 'tahoma' , sans-serif"><a href="https://www.ifood.com.br/" style="color:rgb( 119 , 119 , 119 );line-height:16px" target="_blank" rel="nofollow noopener noreferrer">www.ifood.com.br</a><br data-mce-bogus="1"></div></td></tr><tr><td colspan="2" style="font-family:'arial' , sans-serif;margin:0px" height="35"><table width="190" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="12"> </td><td style="font-family:'arial' , sans-serif;margin:0px"><a href="https://www.facebook.com/iFood?fref=ts" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/facebook_2x.png" width="32" height="32"></a><br data-mce-bogus="1"></td><td style="font-family:'arial' , sans-serif;margin:0px"><a href="https://twitter.com/iFood" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/twitter_2x.png" width="32" height="32"></a><br data-mce-bogus="1"></td><td style="font-family:'arial' , sans-serif;margin:0px"><a href="https://www.instagram.com/iFoodBrasil/" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/instagram_2x.png" width="32" height="32"></a><br data-mce-bogus="1"></td><td style="font-family:'arial' , sans-serif;margin:0px"><a href="https://www.youtube.com/ifood" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/youtube_2x.png" width="32" height="32"></a><br data-mce-bogus="1"></td></tr></tbody></table></td></tr></tbody></table><table style="color:rgb( 34 , 34 , 34 );font-style:normal;font-weight:400;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 );font-size:13px;line-height:normal;font-family:'tahoma' , 'geneva' , sans-serif" width="630" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="font-family:'arial' , sans-serif;margin:0px"><table width="100%" cellspacing="0" cellpadding="0" border="0"></table></td></tr></tbody></table></div></div></div></div></div></div></div></div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><table style="font-family:'arial' , sans-serif;font-style:normal;font-weight:400;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 );color:rgb( 0 , 0 , 0 );font-size:medium" width="450" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td rowspan="6" style="font-family:'arial' , sans-serif;margin:0px" width="105" valign="top" height="120" align="right"><a href="https://www.ifood.com.br/" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/iFood_assinatura3.gif" width="105" height="110"></a><br data-mce-bogus="1"></td><td style="font-family:'arial' , sans-serif;margin:0px" width="18"><br></td><td style="font-family:'arial' , sans-serif;margin:0px" height="22"><div style="line-height:18px;font-family:'montserrat' , 'trebuchet ms' , 'lucida grande' , 'lucida sans unicode' , 'lucida sans' , 'tahoma' , sans-serif;color:rgb( 85 , 85 , 85 )"><p style="margin:0px;line-height:18px"><span style="font-size:14px">Alexandre R Zia<br></span></p></div></td></tr><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="18"><br></td><td style="font-family:'arial' , sans-serif;margin:0px"><div style="font-size:12px;line-height:14px;font-family:'montserrat' , 'trebuchet ms' , 'lucida grande' , 'lucida sans unicode' , 'lucida sans' , 'tahoma' , sans-serif;color:rgb( 228 , 0 , 43 )"><p style="margin:0px;line-height:15px"><span style="line-height:15px"><b>Security</b></span></p></div></td></tr><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="18" height="10"><br></td><td style="font-family:'arial' , sans-serif;margin:0px" height="10"><br></td></tr><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="18"><br></td><td style="font-family:'arial' , sans-serif;margin:0px"><br></td></tr><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="18"><br></td><td style="font-family:'arial' , sans-serif;margin:0px"><div style="font-size:11px;line-height:16px;font-family:'montserrat' , 'trebuchet ms' , 'lucida grande' , 'lucida sans unicode' , 'lucida sans' , 'tahoma' , sans-serif"><a href="https://www.ifood.com.br/" style="color:rgb( 119 , 119 , 119 );line-height:16px" target="_blank" rel="nofollow noopener noreferrer">www.ifood.com.br</a><br data-mce-bogus="1"></div></td></tr><tr><td colspan="2" style="font-family:'arial' , sans-serif;margin:0px" height="35"><table width="190" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="font-family:'arial' , sans-serif;margin:0px" width="12"> </td><td style="font-family:'arial' , sans-serif;margin:0px"><a href="https://www.facebook.com/iFood?fref=ts" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/facebook_2x.png" width="32" height="32"></a><br data-mce-bogus="1"></td><td style="font-family:'arial' , sans-serif;margin:0px"><a href="https://twitter.com/iFood" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/twitter_2x.png" width="32" height="32"></a><br data-mce-bogus="1"></td><td style="font-family:'arial' , sans-serif;margin:0px"><a href="https://www.instagram.com/iFoodBrasil/" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/instagram_2x.png" width="32" height="32"></a><br data-mce-bogus="1"></td><td style="font-family:'arial' , sans-serif;margin:0px"><a href="https://www.youtube.com/ifood" style="color:rgb( 17 , 85 , 204 )" target="_blank" rel="nofollow noopener noreferrer"><img alt="" src="https://www.ifood.com.br/nws/assinatura/youtube_2x.png" width="32" height="32"></a><br data-mce-bogus="1"></td></tr></tbody></table></td></tr></tbody></table><table style="color:rgb( 34 , 34 , 34 );font-style:normal;font-weight:400;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb( 255 , 255 , 255 );font-size:13px;line-height:normal;font-family:'tahoma' , 'geneva' , sans-serif" width="630" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="font-family:'arial' , sans-serif;margin:0px"><table width="100%" cellspacing="0" cellpadding="0" border="0"></table></td></tr></tbody></table></div></div></div></div>
<br>_______________________________________________<br>midPoint mailing list<br>midPoint@lists.evolveum.com<br>https://lists.evolveum.com/mailman/listinfo/midpoint<br></div></div></body></html>