{"id":357,"date":"2011-08-13T17:13:30","date_gmt":"2011-08-13T17:13:30","guid":{"rendered":"http:\/\/blogs.siliconhouse.net\/?p=357"},"modified":"2011-08-15T17:16:33","modified_gmt":"2011-08-15T17:16:33","slug":"best-coding-practices","status":"publish","type":"post","link":"https:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/","title":{"rendered":"Best Coding Practices"},"content":{"rendered":"
\n

Optimising Codes<\/strong><\/p>\n

Optimising your server side scripts such as ASP and PHP is very important for better utilisation of server resources. Even a high end server can fail to deliver the speed and performance that you look for, if the codes are not optimised.<\/p>\n

For ASP & MS Access 2000 Websites:<\/strong><\/p>\n

1. It is a good method to store connection string in a common file. This common file can be included as a header in all the pages, wherever it is required.<\/p>\n

2. Do not use multiple recordsets in a single page. If your program requires mulitple recordsets in a single file, close the already opened recordsets before opening the new one. [ Use rs.close<\/strong> ]<\/p>\n

3. Always close the connection at the end of each asp page. [ Use conn.close<\/strong> ]<\/p>\n

4. Always use provider based or dsnless connection. DSN connections use direct system resources. Moreover, the website is not portable if a System DSN is used.<\/p>\n

5. IMPORTANT : Avoid using multiple loops in a single pages. Most of the programmers make mistakes in handling loops thus the asp pages will not be executed after few hits.<\/p>\n

6. Do not unnecessarily use asp pages. It is strongly adviced to keep the home page as “.html” and not as “.asp”<\/p>\n

7. Access database has a very high restriction on simultaneous users. Hence, if your site receives higher number of hits, plan for migrating to MS SQL as Access cannot handled too many simultaneous users.<\/p>\n

8. Table Size should be kept at minimum. Avoid opening multiple tables at a time. Moreover, avoid querying a single large table.<\/p>\n

For PHP & My SQL:<\/p>\n

<\/strong>1. It is a good method to store connection string in a common file. This common file can be included as a header in all the pages, wherever it is required.<\/p>\n

2. IMPORTANT : Avoid using multiple loops in a single pages. Most of the programmers make mistakes in handling loops thus the asp pages will not be executed after few hits.<\/p>\n

3. Do not unnecessarily use asp pages. It is strongly adviced to keep the home page as “.html” and not as “.php”<\/p>\n

4. Table Size should be kept at minimum. Avoid opening multiple tables at a time. Moreover, avoid querying a single large table.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Optimising Codes Optimising your server side scripts such as ASP and PHP is very important for better utilisation of server<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[77,121,277,146,192,196,197,195,191,194,73,85,114,29,320,16,32,321,19,56,21,120,43,83,318,23,276,226],"class_list":["post-357","post","type-post","status-publish","format-standard","hentry","category-technical","tag-best-web-hosting-india","tag-cheap-domain-name-registration","tag-linux-reseller-hosting-chennai","tag-linux-reseller-hosting-india","tag-live-audiocast","tag-live-flash-media-streaming","tag-live-mobile-streaming","tag-live-real-media-streaming","tag-live-webcast","tag-live-windows-media-streaming","tag-media-streaming","tag-reseller-hosting-chennai","tag-reseller-hosting-india","tag-silicon-hosting","tag-silicon-hosting-reviews","tag-silicon-house","tag-silicon-house-reviews","tag-silicon-reviews","tag-siliconhouse","tag-siliconhouse-chennai","tag-web-hosting","tag-web-hosting-chennai-with-cheapest-price","tag-web-hosting-india","tag-web-hosting-news","tag-whm-reseller1-comment","tag-windows-reseller-hosting","tag-windows-reseller-hosting-chennai","tag-windows-reseller-hosting-india"],"yoast_head":"\nBest Coding Practices - Silicon House - Blogs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Best Coding Practices - Silicon House - Blogs\" \/>\n<meta property=\"og:description\" content=\"Optimising Codes Optimising your server side scripts such as ASP and PHP is very important for better utilisation of server\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/\" \/>\n<meta property=\"og:site_name\" content=\"Silicon House - Blogs\" \/>\n<meta property=\"article:published_time\" content=\"2011-08-13T17:13:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-08-15T17:16:33+00:00\" \/>\n<meta name=\"author\" content=\"Silicon House - Rapid Action Force\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Silicon House - Rapid Action Force\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/\"},\"author\":{\"name\":\"Silicon House - Rapid Action Force\",\"@id\":\"https:\/\/www.siliconhouse.net\/blogs\/#\/schema\/person\/ff07491423a0aa284d087799e56466c1\"},\"headline\":\"Best Coding Practices\",\"datePublished\":\"2011-08-13T17:13:30+00:00\",\"dateModified\":\"2011-08-15T17:16:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/\"},\"wordCount\":364,\"commentCount\":0,\"keywords\":[\"best web hosting india\",\"cheap domain name registration\",\"linux reseller hosting chennai\",\"Linux Reseller Hosting India\",\"Live Audiocast\",\"Live Flash Media Streaming\",\"Live Mobile Streaming\",\"Live Real Media Streaming\",\"Live Webcast\",\"Live Windows Media Streaming\",\"Media Streaming\",\"reseller hosting chennai\",\"reseller hosting india\",\"silicon hosting\",\"silicon hosting reviews\",\"silicon house\",\"silicon house reviews\",\"silicon reviews\",\"siliconhouse\",\"siliconhouse chennai\",\"web hosting\",\"web hosting chennai with cheapest price\",\"web hosting india\",\"web hosting news\",\"whm reseller1 Comment\",\"windows reseller hosting\",\"windows reseller hosting chennai\",\"windows reseller hosting india\"],\"articleSection\":[\"Technical\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/\",\"url\":\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/\",\"name\":\"Best Coding Practices - Silicon House - Blogs\",\"isPartOf\":{\"@id\":\"https:\/\/www.siliconhouse.net\/blogs\/#website\"},\"datePublished\":\"2011-08-13T17:13:30+00:00\",\"dateModified\":\"2011-08-15T17:16:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.siliconhouse.net\/blogs\/#\/schema\/person\/ff07491423a0aa284d087799e56466c1\"},\"breadcrumb\":{\"@id\":\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.siliconhouse.net\/blogs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Best Coding Practices\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.siliconhouse.net\/blogs\/#website\",\"url\":\"https:\/\/www.siliconhouse.net\/blogs\/\",\"name\":\"Silicon House - Blogs\",\"description\":\"Managed Dedicated Servers \u2013 High Availabity Cloud Servers \u2013 Reseller Hosting in India\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.siliconhouse.net\/blogs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.siliconhouse.net\/blogs\/#\/schema\/person\/ff07491423a0aa284d087799e56466c1\",\"name\":\"Silicon House - Rapid Action Force\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/de7475c06cf3d6904766f7c25595a0c4b28dc0b2fd10792414fd2d97dc084fbe?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/de7475c06cf3d6904766f7c25595a0c4b28dc0b2fd10792414fd2d97dc084fbe?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/de7475c06cf3d6904766f7c25595a0c4b28dc0b2fd10792414fd2d97dc084fbe?s=96&d=mm&r=g\",\"caption\":\"Silicon House - Rapid Action Force\"},\"url\":\"https:\/\/www.siliconhouse.net\/blogs\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Best Coding Practices - Silicon House - Blogs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/","og_locale":"en_US","og_type":"article","og_title":"Best Coding Practices - Silicon House - Blogs","og_description":"Optimising Codes Optimising your server side scripts such as ASP and PHP is very important for better utilisation of server","og_url":"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/","og_site_name":"Silicon House - Blogs","article_published_time":"2011-08-13T17:13:30+00:00","article_modified_time":"2011-08-15T17:16:33+00:00","author":"Silicon House - Rapid Action Force","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Silicon House - Rapid Action Force","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/#article","isPartOf":{"@id":"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/"},"author":{"name":"Silicon House - Rapid Action Force","@id":"https:\/\/www.siliconhouse.net\/blogs\/#\/schema\/person\/ff07491423a0aa284d087799e56466c1"},"headline":"Best Coding Practices","datePublished":"2011-08-13T17:13:30+00:00","dateModified":"2011-08-15T17:16:33+00:00","mainEntityOfPage":{"@id":"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/"},"wordCount":364,"commentCount":0,"keywords":["best web hosting india","cheap domain name registration","linux reseller hosting chennai","Linux Reseller Hosting India","Live Audiocast","Live Flash Media Streaming","Live Mobile Streaming","Live Real Media Streaming","Live Webcast","Live Windows Media Streaming","Media Streaming","reseller hosting chennai","reseller hosting india","silicon hosting","silicon hosting reviews","silicon house","silicon house reviews","silicon reviews","siliconhouse","siliconhouse chennai","web hosting","web hosting chennai with cheapest price","web hosting india","web hosting news","whm reseller1 Comment","windows reseller hosting","windows reseller hosting chennai","windows reseller hosting india"],"articleSection":["Technical"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/","url":"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/","name":"Best Coding Practices - Silicon House - Blogs","isPartOf":{"@id":"https:\/\/www.siliconhouse.net\/blogs\/#website"},"datePublished":"2011-08-13T17:13:30+00:00","dateModified":"2011-08-15T17:16:33+00:00","author":{"@id":"https:\/\/www.siliconhouse.net\/blogs\/#\/schema\/person\/ff07491423a0aa284d087799e56466c1"},"breadcrumb":{"@id":"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.siliconhouse.net\/blogs\/best-coding-practices\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.siliconhouse.net\/blogs\/"},{"@type":"ListItem","position":2,"name":"Best Coding Practices"}]},{"@type":"WebSite","@id":"https:\/\/www.siliconhouse.net\/blogs\/#website","url":"https:\/\/www.siliconhouse.net\/blogs\/","name":"Silicon House - Blogs","description":"Managed Dedicated Servers \u2013 High Availabity Cloud Servers \u2013 Reseller Hosting in India","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.siliconhouse.net\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.siliconhouse.net\/blogs\/#\/schema\/person\/ff07491423a0aa284d087799e56466c1","name":"Silicon House - Rapid Action Force","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/de7475c06cf3d6904766f7c25595a0c4b28dc0b2fd10792414fd2d97dc084fbe?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/de7475c06cf3d6904766f7c25595a0c4b28dc0b2fd10792414fd2d97dc084fbe?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/de7475c06cf3d6904766f7c25595a0c4b28dc0b2fd10792414fd2d97dc084fbe?s=96&d=mm&r=g","caption":"Silicon House - Rapid Action Force"},"url":"https:\/\/www.siliconhouse.net\/blogs\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/posts\/357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/comments?post=357"}],"version-history":[{"count":1,"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/posts\/357\/revisions"}],"predecessor-version":[{"id":358,"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/posts\/357\/revisions\/358"}],"wp:attachment":[{"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/media?parent=357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/categories?post=357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.siliconhouse.net\/blogs\/wp-json\/wp\/v2\/tags?post=357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}