[TYPO3] Profiling Typo3

[Daniel Schledermann]

Helge Preuss wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Hi all,
> 
> my Typo3 installation (with extensions I developed myself) takes a
> very long time to respond, both in the backend and in the frontend. I
> have to figure out what causes this.
> 
> Is there any way inside Typo3 to find out where all this time is
> spent? E.g., getting a line which says "x ms spent with SQL queries, y
> ms waiting for I/O, z ms CPU time (of which w ms in function xyz())?
> 
> Or is there any other canonic way of profiling Typo3?
> 

Well..  there are several PHP-debugging tools available. For a large 
project we profiled TYPO3 with "xdebug". "Xdebug" outputs cachegrind 
files, which can be analyzed with WinCacheGrind 
(http://sourceforge.net/projects/wincachegrind/) or KCacheGrind 
(http://kcachegrind.sourceforge.net/cgi-bin/show.cgi).

How to install: http://xdebug.org/install.php. Xdebug is also available 
in both FreeBSD (devel/php5-xdebug) and Gentoo (dev-php5/xdebug) for 
your convinience if you use one of these systems.

It proved extremely useful in finding slow functions, both own, TYPO3's 
and native php.

If you have a lot of database queries, you might want to start with 
optimizing you SQL. Enable slowquerylog on your mysqlserver, so you can 
see what queries is eating your CPU time.



Hope it helps..

/Daniel