[TYPO3-mvc] ExtBase performance

[Tomita Militaru]

> Lorenz Ulrich <mailto:lorenz-typo3 at visol.ch>
> 16 februarie 2013 13:09
> Hi Tomita

Hi Lorenz
>
> You should have a look at external_import.
I did, I prefer to have it in my extension.
>
> 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/
Is there any advantage to this than using INSERTmultipleRows? I just 
tried it with insert and it took 10 seconds, so I'm pretty satisfied 
with it.
>
> Best regards,
>
> Lorenz
>
>
>
> _______________________________________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc
> Tomita Militaru <mailto:militarutomita at gmail.com>
> 16 februarie 2013 11:34
> 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!
> _______________________________________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc