[TYPO3] Newspaper looking for a CMS

[Michael Cannon]

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