[FLOW3-general] Bulk Updates with DQL

[David Sporer]

Hi Karsten,

thank you for your answer.
I've figured out that using DQL-Queries was not neccessary in my case.
I've counted all objects I need to process/update and then took 500 objects
in each iteration of a for-loop.
So I've created a method in my repository that uses limit and offset.

After each iteration I'm executing this - without it the memory usage
increases too much.

$globalPersistence = new
\TYPO3\FLOW3\Persistence\Doctrine\PersistenceManager();$globalPersistence->persistAll();$globalPersistence->clearState();


Anyway I've also managed to use DQL queries where I'm creating a big
CSV-file follwing these instructions:

http://docs.doctrine-project.org/en/2.0.x/reference/batch-processing.html#iterating-large-results-for-data-processing


Sorry that I forgot to update this mail and thank you for your help:-)


Regards

David




2012/11/6 Karsten Dambekalns <karsten at typo3.org>

> Hi.
>
> On 02.11.12 17:17, David Sporer wrote:
> > I've found some hints for DQL-Queries but I couldn't manage to get it
> > working.
>
> What did you try? You should be able to use any DQL Doctrine accepts
> also within a Flow application.
>
>
> Regards,
> Karsten
> --
> Karsten Dambekalns
> TYPO3 Core Developer, Neos / Flow Team
>
> TYPO3 .... inspiring people to share!
> Get involved: typo3.org
> _______________________________________________
> FLOW3-general mailing list
> FLOW3-general at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general
>