Bulk processing/deletion with doctrin via Command - out of memory #54401
Unanswered
UtechtDustin
asked this question in
Q&A
Replies: 1 comment 2 replies
-
Are you sure you cannot use a DQL DELETE? This would be the best solution. Else, adding the |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
We tried to bulk delete an entity which is older than 24 hours (~2200 Entities).
We followed the documentation of doctrine and we always run out of memory.
After some time/debugging we found out that the sql logger seems to be the problem.
We found the parameter
--no-debug
in an other issue(doctrine/dbal#5815) which fixed the problem.But to add an extra parameter which maybe will be forgotten in the future, looks odd for me.
So i found a way to do it via code
which is depcreated, so i also tested this:
Both don't helped out, we still run out of memory.
What is the common/best way to do batch processing/deletion in a command ?
Beta Was this translation helpful? Give feedback.
All reactions