[Flow] Implementing mass deletion in Flow

[François Suter]

Hi all,

I need to create a command controller to delete old records from some 
database table. I'm not sure of the best way to go about this in Flow?

My basic approach would be to query the corresponding repository to get 
all records matching the age criterion, loop over the results and call 
remove() for each of them, then do a persistAll(). However I suspect 
this will issue a SQL DELETE for each record whereas a single query like

DELETE FROM table WHERE age < xxx

would do the job.

Any advice?

TIA

-- 

Francois Suter

Work: Cobweb Development Sarl - http://www.cobweb.ch

TYPO3: Help the project! - http://typo3.org/contribute/

Appreciate my work? Support me -
http://www.monpetitcoin.com/en/francois/support-me/