[TYPO3-english] Slow Queries From TT-News

[Michael Cannon]

Lou,

1. Use XCLASS to override the tt_news methods. Overkill.

2. Create another extension that hooks into tt_news to modifying the
queries being run. Preferred.

Search for hooks in
http://typo3.org/documentation/document-library/extension-manuals/tt_news/3.1.0/view/1/5/

You might check on where the bad queries are getting generated in tt_news
currently and then seeing about overriding the selectConf for them.

Look for processSelectConfHook in
http://typo3.org/extensions/repository/view/news_related/current/info/class.tx_newsrelated.php/

It's activated via selectConfHook  in
http://typo3.org/extensions/repository/view/news_related/current/info/ext_localconf.php/
.


Next, if I recall, your sites are older versions of TYPO3. Once you upgrade
into TYPO3 4.4 or higher with tt_news 3.X, you'll have caching frameworks
available to you to help with the load time issues.

Lastly, have you implemented static file caching? See
http://typo3.org/extensions/repository/view/nc_staticfilecache/current/.

Michael
--
Michael Cannon
The TYPO3 Vagabond <http://typo3vagabond.com> @ in2code.de
Been there, done that, 25 years of coding
Germany +49 (0)160 574 1973
US +1 617 539 6072
http://typo3vagabond.com