[TYPO3-english] ExtBase performance

[Tomiţă MILITARU]

On Sat, Feb 16, 2013 at 12:25 PM, François Suter <fsu-lists at cobweb.ch>wrote:

> Hi Tomiţă,


Hi François


>
>
>  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.
>>
>
> Indeed Extbase has trouble coping with large amount of records. Going for
> straight INSERTs is better. Also if you often have such imports to do, you
> may want to take a look at extension external_import, which is designed
> especially for such a task, mapping imported fields to existing database
> tables, providing a Scheduler task for regular imports, etc.
>

Thanks for the tip, I did it with exec_INSERTmultipleRows and it took 10
seconds.


>
> Cheers
>
> --
>
> Francois Suter
> Cobweb Development Sarl - http://www.cobweb.ch
>
> ______________________________**_________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-**bin/mailman/listinfo/typo3-**english<http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english>
>



-- 
Engr. Tomiţă MILITARU
Certified TYPO3 Integrator
Tel. +40741064681