{"id":3672,"date":"2014-10-07T15:17:33","date_gmt":"2014-10-07T14:17:33","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=3672&#038;lang=en"},"modified":"2017-07-21T09:40:21","modified_gmt":"2017-07-21T08:40:21","slug":"demasy-ini-editor-licence-database","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=3672","title":{"rendered":"DeMaSy INI Editor: Licence Database"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5611\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/Threash.png\" alt=\"\" width=\"814\" height=\"700\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/Threash.png 814w, https:\/\/sdna.lu\/wp-content\/uploads\/Threash-300x258.png 300w, https:\/\/sdna.lu\/wp-content\/uploads\/Threash-768x660.png 768w\" sizes=\"auto, (max-width: 814px) 100vw, 814px\" \/><\/p>\n<ul>\n<li>Bulk threshold: this value is used in database backup\/restore\/copy operations.<\/li>\n<li>Mass copy is processed if the following condition is met:\n<ul>\n<li>The number of records to copy is less than the Threshold value<br \/>\nor<br \/>\nthe Threshold value is equal to zero<\/li>\n<\/ul>\n<\/li>\n<li>Otherwise:\n<ul>\n<li>Copy by range if an Id field exists in the specified table<\/li>\n<li>Copy record by record if no Id field exists in the table<\/li>\n<\/ul>\n<\/li>\n<li>Specify zero for databases with a small amount of data, so the backup\/restore\/copy operations will process all the records in one block.<\/li>\n<li>For large databases, copying records in a single block could not be possible, so you must process them in small blocks. In this case the threshold value can be calculated as the number of records for the largest table in the database divided by 10.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/sdna.lu\/wp-content\/uploads\/Initialization4.jpg\">\u00a0<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bulk threshold: this value is used in database backup\/restore\/copy operations. Mass copy is processed if the following condition is met: The number of records to copy is less than the Threshold value or the Threshold value is equal to zero Otherwise: Copy by range if an Id field exists in the specified table Copy record [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[405,411],"class_list":["post-3672","post","type-post","status-publish","format-standard","hentry","category-utils","tag-demasy-ini-editor","tag-licence-database"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/3672","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3672"}],"version-history":[{"count":4,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/3672\/revisions"}],"predecessor-version":[{"id":5620,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/3672\/revisions\/5620"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}