{"id":10511,"date":"2014-11-19T02:54:19","date_gmt":"2014-11-19T10:54:19","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/?p=10511"},"modified":"2020-04-09T02:55:39","modified_gmt":"2020-04-09T09:55:39","slug":"tuning-topteam-database-performance","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/10511\/tuning-topteam-database-performance\/","title":{"rendered":"Tuning TopTeam Database Performance"},"content":{"rendered":"<p><!-- Start ScreenSteps Content --><\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">What does this action do?<\/h3>\n<div class=\"StepInstructions\">\n<p>It rebuilds <i>TopTeam Database<\/i> indexes that make the database queries faster.<\/p>\n<p>When data fetching becomes faster, loading of data in <i>TopTeam<\/i> editors such as <i>Repository Explorer, List editors, Tree editors, Document Generation,<\/i> etc. also becomes faster.<\/p>\n<p>You can access this action from <i>Administration &gt; Perform System Maintenance &gt; Perform Database Tune-up<\/i>. Refer to the image below.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/09\/wpid36493-media_1478252915872-1-1.png\" alt=\"wpid36493-media_1478252915872-1-1.png\" width=\"747\" height=\"573\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">When to perform this action?<\/h3>\n<div class=\"StepInstructions\">\n<p>It is recommended that this action should be performed once a month.<\/p>\n<p>If updates to <i>TopTeam <\/i>repository are high (.e.g. more than 500 updates per day), it is then recommended to perform this action once in a week.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><!-- End ScreenSteps Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What does this action do? It rebuilds TopTeam Database indexes that make the database queries faster. When data fetching becomes faster, loading of data in TopTeam editors such as Repository Explorer, List editors, Tree editors, Document Generation, etc. also becomes faster. You can access this action from Administration &gt; Perform System Maintenance &gt; Perform Database Tune-up. Refer to the image below. When to perform this action? It is recommended that this action should be performed once a month. If updates to TopTeam repository are high (.e.g. more than 500 updates per day), it is then recommended to perform this action <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[281,313],"class_list":["post-10511","post","type-post","status-publish","format-standard","hentry","category-administration","tag-database","tag-performance"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-2Jx","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/10511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=10511"}],"version-history":[{"count":17,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/10511\/revisions"}],"predecessor-version":[{"id":49703,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/10511\/revisions\/49703"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=10511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=10511"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=10511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}