{"id":5439,"date":"2016-07-27T13:02:17","date_gmt":"2016-07-27T12:02:17","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=5439&#038;lang=en"},"modified":"2016-07-27T13:56:35","modified_gmt":"2016-07-27T12:56:35","slug":"data-best-pratices","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=5439","title":{"rendered":"Data best pratices"},"content":{"rendered":"<p>There is some information for best Data performances.<\/p>\n<ul>\n<li>Link the following tabled your Client Databases to the LINK Database:\n<ul>\n<li>Country<\/li>\n<li>CountryCurrency<\/li>\n<li>CountryIndex<\/li>\n<li>CountryIndexType<\/li>\n<li>CountryName<\/li>\n<li>CountryPhone<\/li>\n<li>Currency<\/li>\n<li>CurrencyRate<\/li>\n<li>Holiday<\/li>\n<li>Reminder<\/li>\n<li>ReminderType<\/li>\n<li>ReminderTypeName<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li>Verify if you can delete some old Currency rates, for example if you have Currency rates from 2002 and you don&#8217;t need them anymore, you can delete them or keep at least the last Currency rate of every year.<\/li>\n<\/ul>\n<ul>\n<li>On the Versionlink Table , you should only have records for your current environment.<\/li>\n<\/ul>\n<ul>\n<li>If you use Transaction Log, you can archive and\/or Delete the old records in TransLog Table<\/li>\n<\/ul>\n<ul>\n<li>In DeMaSy Utilities on INIEditor screen, you can delete all the old DBId records. (Only if you use SQLServer)<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5446\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/OldDbid.jpg\" alt=\"OldDbid\" width=\"812\" height=\"699\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/OldDbid.jpg 812w, https:\/\/sdna.lu\/wp-content\/uploads\/OldDbid-300x258.jpg 300w, https:\/\/sdna.lu\/wp-content\/uploads\/OldDbid-768x661.jpg 768w\" sizes=\"auto, (max-width: 812px) 100vw, 812px\" \/><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There is some information for best Data performances. Link the following tabled your Client Databases to the LINK Database: Country CountryCurrency CountryIndex CountryIndexType CountryName CountryPhone Currency CurrencyRate Holiday Reminder ReminderType ReminderTypeName Verify if you can delete some old Currency rates, for example if you have Currency rates from 2002 and you don&#8217;t need them anymore, [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67],"tags":[293,457,8,458],"class_list":["post-5439","post","type-post","status-publish","format-standard","hentry","category-technical","tag-currency","tag-currencyrate","tag-database","tag-performance"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/5439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5439"}],"version-history":[{"count":5,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/5439\/revisions"}],"predecessor-version":[{"id":5447,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/5439\/revisions\/5447"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}