[TYPO3-mvc] Simpleblog extension database queries

[Chris Wolff - AERTiCKET AG]

Hi, Robert,
i would say do it the extbase way! The extbase framework overall is a a much better expirence thenn the pi base. And a lot of the concepts are comparable to
typo3 FLOW which is an added bonus. As Christian Kartnig, pointed out Database performance might be an issue. But this depents on your use case
if you have a lot of data which will be cached by the typo3 frontend cache the query Performance is not as important. And with the use oft he typo3 caching_framework
you are even able to finetune your caching. Which might help you avoid some re-rendering anyway if your extension cache is still Good.

Extbase tries to take out the pain of thinking about the database. And storage. All you have to think about are objects. Thats a realy good thing.
But if needed you could optimize, and go deeper, do a direct query, build your own caching system.... But i think optimizing ist he second step and should only be done if you see the performance is an issue.
Don't over optimize and remove all the good parts the extbase framework gives you.

I think pi_base will be removed in the long run from the typo3-core.. so to be future proof extbase is definitifly the way to go. 

Regards chris

-----Ursprüngliche Nachricht-----
Von: typo3-project-typo3v4mvc-bounces at lists.typo3.org [mailto:typo3-project-typo3v4mvc-bounces at lists.typo3.org] Im Auftrag von Christian Kartnig
Gesendet: Freitag, 28. November 2014 09:25
An: typo3-project-typo3v4mvc at lists.typo3.org
Betreff: Re: [TYPO3-mvc] Simpleblog extension database queries

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
>

_______________________________________________
TYPO3-project-typo3v4mvc mailing list
TYPO3-project-typo3v4mvc at lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc