How to optimize a query in which you need to send, for example, 3 thousand rows and add them to the database?

Question

symfony

Tell me how to optimize a query in which you need to send, for example, 3 thousand rows and add them to the database?

Send json:

{
"users": [
1000,
...
4000
]
}

both the server and postman start to fall off. how can i solve the problem?

Answer 1

Start a transaction manually, prepare a request and send the data already. After sending all the data, make a commit.
If about the doctrine, then read this

Answer 2

If you need the page not to freeze while all this is being done, then use Message (MessageHandler) in symphony, it is very well implemented. Let these requests be made asynchronously. You can see how this is done on symfonycast,