[TYPO3-mvc] Simpleblog extension database queries

[Christian Kartnig]

Hi Robert,

it is possible to build large extensions with extbase, but it is correct 
that extbase has some performance issues, especially with database 
performance.

You can experiment with lazy loading, or you can partially bypass 
Extbase's ORM functionality for better performance.
E.g. it is possible to build your SQL queries by hand, so you can 
optimize them, and you can even use raw query results, if you don't want 
extbase to build objects from all the returned records. (e.g. if you 
just need uids for a list)

But be prepared that you will spend a considerable amount of time on 
tuning extbase performance.

best regards,
Christian


Am 27.11.14 17:06, schrieb Robert W:
> Hello,
>
> We wanted to get familiar with the new Extbase development, so I worked
> through the TYPO3 Extbase book "TYPO3 Extbase" and built the simpleblog
> extension. Our team is about to work on a very large project and trying
> to decide which way to code the new extensions. There were some concerns
> about Extbase and database performance, so I started poking around.
>
> There are a few threads where the performance was critizied, so I did a
> little testing. I simulated a test set of 100 blogs and the associated
> backend tables (comments, posts, tags, etc.). When initially hitting the
> page where the simpleblog is displayed and watching the SELECTs per
> Second in MySQL workbench, I am hitting consistently over 500 queries at
> one point when the page is processing (to paint 100 blogs).
>
> At this point, my questions are:
> 1.) Are folks using Exbase for TYPO3 6.2.x development, and if so, how
> are they resolving the database hit above?
> Or
> 2.) Are developers using some hybrid version of development with
> Kickstarter?
>
> We greatly appreaciate you input in this matter, so that we can make a
> solid decision moving forward.
>
> Best Regards
> Robert
>