Improve Performance for Websites with a Database Back-end & Dynamic Content

Improve Performance for Websites with a Database Back-end & Dynamic Content

How to improve the performance of web pages, and the overall performance of a website by minimise front-end processing and additional server/client DNS requests required to fully load each page.

1. Identify the areas/scripts for a website which are frequently used
2. Identify scripts which take the longest time to process or load
3. Identify DNS Requests that can be removed from front-end pages
4. Create scripts to perform background processing, then store website content (HTML) in a database table.
5. Replace code in scripts to retrieve the pre-formatted content from a database

The techniques described below focus on reducing the processing requirements and DNS requests required to generate and load a page for both the server-side and client-side aspects of a web application or website. The steps explain how to identify, and reduce the amount of processing required by the front-end server of a website by performing background tasks to complete processing which would usually take a long time to complete. This includes identifying scripts/pages which are frequently used, and considering reducing the loading time by retrieving pre-prepared html from a database instead of processing and displaying from the front-end script. The background tasks will periodically execute scripts which will perform the processing required to generate and store the pre-formatted html in a database table ready for retrieval when loading the web page.

SEO Tips: Keyword Research, Target Key Phrases, Site Navigation

SEO Tips for Website & Database Application Development

I wanted to share a few of my experiences with developing websites and database applications in relation to optimising the structure, navigation, layout and content of websites to help increase rankings in popular search engines, including Google, Bing and Yahoo. Some key areas covered include designing and developing a website to have a logical page hierarchy and navigation paths. I have developed a range of websites both static and interactive with a database or sometimes file system back-end to enable content to be published and maintained dynamically.

The Search Engine Optimisation techniques described below are based on my own personal experiences with various methods of building a dynamic website. They are basic in nature, and provide an idea of just some of the many techniques to optimise a website for Search Engines. Any concepts or conclusions reached are a result of my own research, experimentation and opinion. As there are numerous factors involved when Search Engines rank a site or page, there may be factors other than the techniques which I perceived to be the reason for an increase in search engine ranking. If you have a different opinion, or would like to discuss the techniques below, feel free to post a reply to the thread.

Web Programming, SEO & SharePoint Resources

Web-Resource.org - SharePoint, Web Programming & SEO Resources

Web-resource.org provide a range of resources from around the web for Web Development & Programming, SharePoint & InfoPath Development and Search Engine Optimisation. Resources have been hand selected by the team at Web-Resource.org, and suggested by users.

Some of the many resources include: