Is it a better choice to find out all the data in batches, then update the data fields found, and then save?

Is it a better choice to find out all the data in batches, then update the data fields found, and then save?

Writing like this is not elegant，However, it can reduce the number of times to execute sql.

I don't know which of the two methods to choose. What's your opinion

Is it a better choice to find out all the data in batches, then update the data fields found, and then save?

I don't think this is the best option. Like you mentioned, the code is not elegant. Generally, users don't update categories frequently and there aren't too many categories. It has little impact on performance so we don't need to write complex code to optimize it.

I also tried finding other ways to reduce the sql statement, but they either difficult to maintain or too complex. If you have any better ideas, please let me know!

I think you are right

Please use rebase instead of merge

Done👌