“Why do you need to split complex join-table operations into multiple single-table queries?” 》When we are optimizing the system, a common operation is to dismantle the complex join-table operation into multiple single-table operations, and then perform the join in the application. Why do you want to do this? I believe everyone can list a few points. However, “High Performance MySQL Fourth Edition” has a good summary of this, which is worthy of careful consideration. An excerpt follows…
This article is transferred from https://jiajunhuang.com/articles/2023_02_03-mysql.md.html
This site is only for collection, and the copyright belongs to the original author.