General WEB programs now choose the former, and they also tend to use single-table queries.
Database stored procedures involve difficulty in development and debugging, and the performance optimization effect of stored procedures is not obvious. Moreover, a cache layer and middleware may be added between the application layer program and the database layer. Therefore, it is better to use SQL independently in the application layer code
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
General WEB programs now choose the former, and they also tend to use single-table queries.
Database stored procedures involve difficulty in development and debugging, and the performance optimization effect of stored procedures is not obvious. Moreover, a cache layer and middleware may be added between the application layer program and the database layer. Therefore, it is better to use SQL independently in the application layer code
It is generally not recommended to use stored procedures