How to Optimise mysql queries, importance of closing db connections

How to optimize MYSQL queries The MYSQL query optimization takes the advantages of indexes, but it is also uses other information.For example, if we use the following query, MYSQL will execute it very quickly, no matter how large the table is. SELECT * FROM table_name WHERE 0; If you execute the query, MYSQL looks at … Read moreHow to Optimise mysql queries, importance of closing db connections

What is responsive website templates or themes and benifits

What is Responsive website theme? A Responsive theme is simply means a website that has been developed and the contents, images and structure of the website remains the same in all the devices(such as desktop, smartphones, tablets etc.,).For example, if the user visits the site in desktop, the full view of the site is displayed. If … Read moreWhat is responsive website templates or themes and benifits

What is indexing in database , how to optimize the mysql database table

Indexing in database / how to optimize mysql table Indexing is a data structure technique, which is used to efficiently retrieve a records from the database files, based on some attributes on which the indexing as been done. For example, indexing in database is also similar to what we seen in books. Indexing can be … Read moreWhat is indexing in database , how to optimize the mysql database table

Benefits of linking social media into your website

Benefits of linking social media into your website Using links in your website, is playing a major role for rankings in a search engine. For example, Google automatically associate your social media pages with your company/organization when recognizing the links on your site. Many ways are available to integrate social media on your website. Sharing This is … Read moreBenefits of linking social media into your website