{"id":297,"date":"2018-11-29T17:08:59","date_gmt":"2018-11-29T17:08:59","guid":{"rendered":"http:\/\/www.cdesystems.co.uk\/?page_id=297"},"modified":"2018-11-29T17:08:59","modified_gmt":"2018-11-29T17:08:59","slug":"tuning","status":"publish","type":"page","link":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/?page_id=297","title":{"rendered":"Performance Tuning"},"content":{"rendered":"<h2>Slow systems cause frustration for your clients, staff and costs you money.<\/h2>\n<p>We can make your Access database faster and more reliable using our 4 point plan:<\/p>\n<h2>1. Monitor Workload<\/h2>\n<ul>\n<li>Measure database speed and query use under normal operation.\n<ul>\n<li style=\"list-style-type: none;\"><\/li>\n<\/ul>\n<\/li>\n<li>Identify memory, resource and CPU bottlenecks.<\/li>\n<\/ul>\n<h2>2. Queries<\/h2>\n<ul>\n<li>Analyse and streamline the most used and resource-intensive queries and functions.<\/li>\n<\/ul>\n<h2>3. Indexes<\/h2>\n<ul>\n<li>Review and update indexes to make the database structures more efficient.\n<ul>\n<li style=\"list-style-type: none;\"><\/li>\n<\/ul>\n<\/li>\n<li>Optimise speed for complex calculation and data processing.<\/li>\n<\/ul>\n<h2>4. Settings<\/h2>\n<ul>\n<li>Default database and network settings can lead to bad performance.<\/li>\n<li style=\"list-style-type: none;\"><\/li>\n<li>Sometimes fine tuning the configuration can get you 20-30% performance increases.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Slow systems cause frustration for your clients, staff and costs you money. We can make your Access database faster and more reliable using our 4 point plan: 1. Monitor Workload Measure database speed and query use under normal operation. Identify memory, resource and CPU bottlenecks. 2. Queries Analyse and streamline the most used and resource-intensive [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":289,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-297","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=297"}],"version-history":[{"count":0,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/297\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/289"}],"wp:attachment":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}