[TYPO3-mvc] ExtBase performance

[Lorenz Ulrich]

Hi Tomita

You should have a look at external_import.

If you want to do it in your own extension, I suggest using TCEmain:
http://blog.tolleiv.de/2010/03/handling-data-in-typo3-with-tcemain/

Best regards,

Lorenz

Am 16.02.2013 10:34, schrieb Tomita Militaru:
> Hello,
>
> I am trying to import a CSV file with over 65.000 records using an
> ExtBase extension I'm building. But seems like that ExtBase can't handle
> that many objects or are too many as it takes nearly 30 minutes to store
> them in the database.
>
> To test, I tried something like this:
>
> $persistenceManager =
> t3lib_div::makeInstance('Tx_Extbase_Persistence_Manager');
>
> for($i = 0; $i < 65000; $i++) {
> $objectNew = t3lib_div::makeInstance('Tx_MyExtension_Domain_Model_Object');
>
> $objectNew->setZip('123456');
> $objectNew->setHouse(5);
> $this->objectRepository->add($objectNew);
> }
> $persistenceManager->persistAll();
>
>
> Should I just do it with plain INSERTs as it worked much better using
> that method? Is there a more efficient way to store objects in ExtBase
> that I am not aware of?
>
> Thanks!