Sometimes we may face about performance issues while opening a website. Not only databases but we need to optimize our programming code also. MySQL Best Practices means few tips to optimize the MySQL query: Avoid SELECT * and use particular fields from a table what you require. Use ENUM rather than VARCHAR because ENUM type […]
Using robots.txt file you can give instructions about their site to web robots. While search engine bot comes to your blog they have limited resources to crawl. So after certain crawling they stop and you website may not indexed. Sometimes there may be some folder or pages you do not want to crawl. For example […]
MyISAM vs Innodb – both are commonly used engines on MySQL servers and they both have their unique advantages and disadvantages against each other. MyISAM is the default storage engine type for MySQL 5.0 but the Cloud Sites environment defaults the storage engine to Innodb. MyISAM vs Innodb: MyISAM: Table level locking. Innodb: Row level […]
In this tutorial you will get the basic knowledge of KnockoutJS and how to use on programming. Basically it is a JavaScript library based on MVVM pattern i.e. Model-View-View-Model by which developer build rich and responsive websites. It separates the application model, view and view model. It supports most of browsers i.e. Firefox 3.5+, IE […]
URLs or Uniform Resource Locator is location of html document web. It consists of three parts i.e. Protocol, Domain and Resource path. For e.g. http://www.namasteui.com/index.php where http is protocol, www.namasteui.com is domain and index.php is resource path. It also has a query string i.e. http://www.namasteui.com/index.php?value=1&page=3 So the query string for the above url is: ?value=1&page=3 […]