Steps to make MySQL produce optimized results » Identify the queries that execute slowly » Watch for Opened Sql connections » Carry benchmark test on Queries » Execute queries with Explain statement to the performance of each queries (more…)

Numeric Data type in MySQL Choosing the right data type can create significant improvement in application performance. Many programmers/developers who opt to choose MySQL as the backend for their operations often fail miserably in choosing the most efficient data types. (more…)