Traditionally in MySQL, we execute queries sequentially i.e. queries will be executed one after other only. So if we are executing multiple queries then each query will be blocked until and unless the previous query is executed. This works to a limit, but as the system expands, this method ends up having a significant impact on overall system performance and latency.
Suppose you are developing a web application and you are in a situation to fetch a large amount of data from database before page load. In such situations your webpage is going to take a long time to load. For
Francis Varghese
Lead Software & DevOps Engineer with 13+ years of experience developing, deploying, automating, managing & monitoring leading-edge web, mobile & SAP solution applications.
