[TYPO3-dev] Re: Extbase extension performance

[Elmar]

Back to the roots!

I think it kind of crazy to import a CSV file line by line through an ORM layer, as an ORM layer itself is a workaround by nature to address the problem of the object relational missmatch. CSV values are genuine relational data and no objects at all.

It's one line on the command line to import a whole CSV file into a MySql table with mysqladmin. If you need to restructure the imported table, you need one SQL query to sort the data into a second target table. 

Overall 2 lines of code on the shell and you can even send that from within PHP.

An ORM layer is a solution pattern for a special kind of problem. To think it a golden hammer is definitly an anti-pattern. 

Regards

Elmar