http://forge.typo3.org/http://forge.typo3.org/themes/typo3_forge/favicon/favicon.png?17058661692021-11-20T19:07:24ZTYPO3 ForgeTYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4581352021-11-20T19:07:24ZSybille Peterssypets@gmx.de
<ul><li><strong>Related to</strong> <i><a class="issue tracker-10 status-2 priority-4 priority-default" href="/issues/93547">Epic #93547</a>: Collection of problems with large sites</i> added</li></ul> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4581362021-11-20T19:59:36ZGerrit Code Review
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Under Review</i></li></ul><p>Patch set 1 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243">https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243</a></p> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4581732021-11-22T07:06:44ZSybille Peterssypets@gmx.de
<ul><li><strong>Tags</strong> changed from <i>memory hog, memory, out of memory, slurping</i> to <i>memory hog, memory, out of memory, large-site</i></li></ul> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4584892021-11-26T15:36:11ZSybille Peterssypets@gmx.de
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/journals/458489/diff?detail_id=375835">diff</a>)</li></ul> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4585532021-11-27T13:06:09ZGerrit Code Review
<ul></ul><p>Patch set 2 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243">https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243</a></p> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4585552021-11-27T13:10:46ZGerrit Code Review
<ul></ul><p>Patch set 3 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243">https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243</a></p> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4585582021-11-27T13:15:03ZGerrit Code Review
<ul></ul><p>Patch set 4 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243">https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243</a></p> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4585612021-11-27T13:29:27ZSybille Peterssypets@gmx.de
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/journals/458561/diff?detail_id=375875">diff</a>)</li></ul> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4585622021-11-27T13:47:13ZGerrit Code Review
<ul></ul><p>Patch set 5 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243">https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243</a></p> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4585742021-11-27T15:36:53ZGerrit Code Review
<ul></ul><p>Patch set 6 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243">https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243</a></p> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4588662021-11-29T14:06:48ZGerrit Code Review
<ul></ul><p>Patch set 7 for branch <strong>main</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243">https://review.typo3.org/c/Packages/TYPO3.CMS/+/72243</a></p> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4626982022-01-29T21:51:32ZSybille Peterssypets@gmx.de
<ul><li><strong>Status</strong> changed from <i>Under Review</i> to <i>Closed</i></li></ul><p>Is abandoned.</p> TYPO3 Core - Bug #96042: Row update wizard may consume too much memory for tables with many records and contenthttp://forge.typo3.org/issues/96042?journal_id=4870542023-02-15T08:24:32ZPhilipp Kitzberger
<ul></ul><p><a class="user active user-mention" href="http://forge.typo3.org/users/36294">@Sybille Peters</a>, had a similar out-of-memory issue with a custom console command using "QueryBuilder->update()" within a loop, iterating over 4000 records. Which is not that many.</p>
<p>I ended up changing it to "Connection->update()" to bring down runtime from 20 minutes (!!!) to 1-2 seconds.</p>
<p>Maybe we should put some hint into the docs?</p>