{"id":1485,"date":"2020-05-07T11:37:40","date_gmt":"2020-05-07T11:37:40","guid":{"rendered":"https:\/\/sdf-docs.mansystems.com\/docs\/acr-rules\/performance\/persistent-entities-should-have-indices\/"},"modified":"2022-02-08T09:32:02","modified_gmt":"2022-02-08T09:32:02","slug":"performanceminamountindices","status":"publish","type":"docs","link":"https:\/\/sdf-docs.clevr.com\/?docs=acr-rules\/performance\/performanceminamountindices","title":{"rendered":"Persistent entities should have indices"},"content":{"rendered":"\n<p> Introduced in version 1.10 (May 2020) <\/p>\n\n\n\n<p>This rule is not a hard requirement, but rather a reminder to consider indices. Developers often forget to create indices and this way they are warned and can either create an index (or more) or decide that it is not necessary and whitelist the violation.<\/p>\n\n\n\n<p>Configure a minimum amount of indices for this rule. Default is 1.<\/p>\n\n\n\n<div class=\"wp-block-group is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Additional resources on indices <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Mendix documentation: <a href=\"https:\/\/docs.mendix.com\/howto\/general\/community-best-practices-for-app-performance#3-index-best-practices\" target=\"_blank\" rel=\"noreferrer noopener\">Implement Community Best Practices for App Performance &#8211; Studio Pro 9 How-to&#8217;s | Mendix Documentation<\/a>. <\/li><li>A recommended read is this great blog by Martin Leppen, Mendix MVP at Cape Group: <a href=\"https:\/\/medium.com\/mendix\/performance-modelling-in-mendix-indexes-e5d6688d2701\" target=\"_blank\" rel=\"noreferrer noopener\">Performance modeling in Mendix \u2014 Indexes | by Martin Leppen | Mendix Community | Feb, 2022 | Medium<\/a>. Explaining everything you should know around indices.<\/li><\/ul>\n<\/div>\n\n\n\n<p><\/p>\n","protected":false},"featured_media":0,"parent":95,"menu_order":27,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-1485","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/1485"}],"collection":[{"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1485"}],"version-history":[{"count":3,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/1485\/revisions"}],"predecessor-version":[{"id":2392,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/1485\/revisions\/2392"}],"up":[{"embeddable":true,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/95"}],"next":[{"title":"The Uniqueness Validation should be set to Database","link":"https:\/\/sdf-docs.clevr.com\/?docs=acr-rules\/performance\/projectperformanceuniquenessvalidation","href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/1920"}],"prev":[{"title":"Loops should not have loops inside","link":"https:\/\/sdf-docs.clevr.com\/?docs=acr-rules\/performance\/loopinloop","href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/1149"}],"wp:attachment":[{"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1485"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=1485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}