[TYPO3-english] ExtBase performance

[François Suter]

Hi Tomiţă,

> 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.

Cheers

-- 

Francois Suter
Cobweb Development Sarl - http://www.cobweb.ch