[TYPO3-ttnews] tt_news 2.6.0 is 10 times faster than 2.5.2!!

[Rupert Germann]

hi,

no, I'm not Mr. DEng. A.P. Rilfool and I've not written a patch to rename
TYPO3 to TYPO4 ;-)
this is real.

the tt_news 2.6.0branch develops further and since I solved some
compatibility problems with TYPO3 4.0 I will merge it back to trunk soon.

I'm currently evaluating ZendStudio for eclipse and I managed to get the
profiler to run with TYPO3 4.2 and tt_news: fascinating thingy!! ;-)

you can see some results of this investigations in my latest commits [1] and
in the PDF under [2]. I removed quite a lot of unnessecary, double, triple
routines and functions calls which are quite easy to spot with the
profiler's "function invocation statistics".

example: 
the statistic revealed that each call to getQuery/getWhere invokes a call to
cObj->enableFields (again) and a call to checkPidList (again). Both
informations are already available as member vars after the init() function
has been called. Removing this double calls has quite a big impact on
functions like displayAmenu() which makes as much queries as archive
periods have been found between the oldest and the newest news article.
Looping through all found archive periods can't be prevented but now the
count-query for each period is generated and executed much faster. 
How much "much faster" is, depends of course on many other factors: 
 - is the pid_list used and if yes, how big is it?
 - is mysql caching enabled? 
and also on the TYPO3 version. Yes, 4.2 is faster than 4.1. Why? 
core changelog says:
----
2008-02-02  Martin Kutschker  <masi at typo3.org>
        * #7351: Introduce $ACCESS_TIME/$SIM_ACCESS_TIME to improve MySQL query
cache usage   
----

little change but huge impact - THANKS with 3 ***, Masi !!! :-)

To get some numbers I made some tests with tt_news 2.6.0 and 2.5.2 running
under TYPO3 4.2 and 4.1 with different configuration options. I compiled
the results in a PDF which you can download under [2]

greets
rupert


 

[1]
http://typo3xdev.svn.sourceforge.net/viewvc/*checkout*/typo3xdev/tx_ttnews/branches/tx_ttnews-2.6.0dev/ChangeLog

[2] http://rgdata.de/fileadmin/user_upload/tt_news_profiling.pdf