Programming

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 …

How to Optimise mysql queries, importance of closing db connectionsRead More »

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 …

What is responsive website templates or themes and benifitsRead More »

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 …

What is indexing in database , how to optimize the mysql database tableRead More »