I have mentioned on the Internet that multi-table join queries have very low performance and try to avoid join operations. I also encountered this big problem in the project. some reports need several tables for join queries to get data, however, too much data in the table will increase the query time. I tried to replace the stored procedure, but I still only wrote join statements in the stored procedure. isn't it correct? Thank you for optimizing the performance of multi-table queries in the mysql stored procedure database
I have mentioned on the Internet that multi-table join queries have very low performance and try to avoid join operations. I also encountered this big problem in the project. some reports need several tables for join queries to get data, however, too much data in the table will increase the query time. I tried to replace the stored procedure, but I still only wrote join statements in the stored procedure. isn't it correct? Thank you for your advice.