java - 牵扯数据库的开发在sql语句全放在开发语言中和在数据库中写好存储过程如何寻找平衡？

Answer 1

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

Answer 2

It is generally not recommended to use stored procedures