[Typo3-dev] Is Typo3 Robust ?

[Bas v.d. Wiel]

Just curious, did you try to profile the queries? Sometimes rearranging

>>the query helps.
>>    
>>
>
>Sure :) "EXPLAIN", fine-tune indexes, everything. I constantly work with
>databases since 1997.
>
>Dmitry.
>_______________________________________________
>Typo3-dev mailing list
>Typo3-dev at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>  
>
I fear TYPO3 might spend quite a bit more time in PHP than a typical
forum would. I have yet to learn the intricacies of the TYPO3 core and
its API but it appears to me that TYPO3 is making extremely heavy use of
PHP arrays to shuffle all kinds of data around and tends to rely less on
the 'intelligence' built into the database server. This is just an
observation comparing TYPO3 to other PHP applications I've worked on. I
coud very well be wrong about this, but in the view of the DBAL project
I'd say it's a good choice to rely on PHP instead of the specific
features of the RDBMS. Maybe it could be faster if you hard-code for
MySQL-specific functionality, but others here probably have much more
informed opinions on this than I do..

I occasionally troubleshoot an intranet-like site in an educational
settings. It has close to 1000 BE-users, a little over 5000 pages and is
continuously growing. TYPO3 proved itself to me when this whole site
managed to stay up and responsive for many months on end using nothing
more than a totally standard Apple G4 Cube, 400Mhz., built in 1998, for
a server. Talk about a development playground running out of control..
(I'm not _managing_ this project, thank $favoriteDeity, but it shows
TYPO3's capabilities on small hardware). No crashes here whatosoever due
to lack of capacity, only a single power outage last week.. which is not
TYPO3's fault of course.

Regards,

Bas