{"id":69,"date":"2006-01-18T10:18:00","date_gmt":"2006-01-18T08:18:00","guid":{"rendered":"http:\/\/www.forksoft.de\/blog\/2006\/01\/18\/navision-performanceprobleme-beim-renaming\/"},"modified":"2006-10-05T12:04:25","modified_gmt":"2006-10-05T10:04:25","slug":"navision-performanceprobleme-beim-renaming","status":"publish","type":"post","link":"http:\/\/www.navision-blog.de\/blog\/2006\/01\/18\/navision-performanceprobleme-beim-renaming\/","title":{"rendered":"Navision: Performanceprobleme beim Renaming?"},"content":{"rendered":"<p>Ein Rename eines Datensatzes ist in Navision aufgrund der &#220;berpr&#252;fung von TableRelations sehr langsam. Wenn man jedoch genau wei&#223; was man tut, dann kann man jedoch relativ leicht eine enorme Performancesteigerung erreichen:<\/p>\n<div class=\"wlWriterSmartContent\" id=\"57F11A72-B0E5-49c7-9094-E3A15BD5B5E6:bc1bc2c2-1c45-41d6-804b-10df3c9657a1\" contenteditable=\"false\" style=\"padding-right: 0px; display: inline; padding-left: 0px; float: none; padding-bottom: 0px; margin: 0px; padding-top: 0px\">\n<pre style=\"background-color:White;\"><div><!--\n\nCode highlighting produced by Actipro CodeHighlighter (freeware)\nhttp:\/\/www.CodeHighlighter.com\/\n\n--><span style=\"color: #000000; \">xRec :<\/span><span style=\"color: #000000; \">=<\/span><span style=\"color: #000000; \"> Rec; \nDELETE; \nINIT; \nRec :<\/span><span style=\"color: #000000; \">=<\/span><span style=\"color: #000000; \"> xRec; \nRec.MyKeyField :<\/span><span style=\"color: #000000; \">=<\/span><span style=\"color: #000000; \"> newKeyValue;\nRec.MyField :<\/span><span style=\"color: #000000; \">=<\/span><span style=\"color: #000000; \"> newValue1;\n ... \nInsert;\n<\/span><\/div><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Ein Rename eines Datensatzes ist in Navision aufgrund der &#220;berpr&#252;fung von TableRelations sehr langsam. Wenn man jedoch genau wei&#223; was man tut, dann kann man jedoch relativ leicht eine enorme Performancesteigerung erreichen: xRec := Rec; DELETE; INIT; Rec := xRec; Rec.MyKeyField := newKeyValue; Rec.MyField := newValue1; &#8230; Insert;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/posts\/69"}],"collection":[{"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/comments?post=69"}],"version-history":[{"count":0,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/posts\/69\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/media?parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/categories?post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/tags?post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}