[TYPO3-dev] Extbase extension performance

[Tomiţă MILITARU]

On Sat, Feb 16, 2013 at 10:47 AM, Frans Saris <franssaris at gmail.com> wrote:

> Hi Tomiţă,
>

Hi Frans


>
> Have you debugged to see where most of the delay occurs?
>

The problem is at persistAll(), so when storing the objects in the database.


> A plain insertinto will definitely be faster because you don't have the
> object overhead.
>

True, but I thought I would be safe with under 100 k objects, it's a pitty
to return to insertinto's


>
> Gr. Frans
>  Op 16 feb. 2013 09:20 schreef "Tomiţă MILITARU" <
> tomita.militaru at gmail.com>
> het volgende:
>
> > Hello,
> >
> > I am building an extbase extension that imports from a CSV file > 100.000
> > records, reading line by line and adding object by object to the
> > repository. But that never finishes as it takes way too long, 30 k
> records
> > in 20 minutes and still running.
> > Is it a better way to do it or should I just switch to the classic
> > exec_INSERTquery functions as it worked much better this way than using
> > extbase.
> >
> > Thanks!
> > _______________________________________________
> > TYPO3-dev mailing list
> > TYPO3-dev at lists.typo3.org
> > http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev
> >
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev
>



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