I've been staying away from modifying the news queries, but the indexes being added for the tt_news, tt_news_category_mm, and tt_news_category to the database really do help.
Watching a MySQL slow_query_log for anything over 1 second for a couple of days with logging join table-less enabled really tells you what needs better indexing in TYPO3. Michael ----- Michael Cannon President of Cannonbose, LLC +1 (800) 559-9773 | +1 (603) 559-9773 | Fax : +1 (802) 609-2776 On Aug 8, 2007, at 4:10 AM, Dmitry Dulepov [typo3] wrote: Michael Cannon wrote: > Regarding slow news pages, have indexes been created on deleted, > hidden, > local_uid, foreign_uid, and other prominent fields? It should be a combination of fields. Just having individual indexes does not give much result. Queries have to be expplored and tuned... Michael ----- Michael Cannon President of Cannonbose, LLC +1 (800) 559-9773 | +1 (603) 559-9773 | Fax : +1 (802) 609-2776 _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.netfielders.de http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english