[TYPO3-dev] Fatal Query

[Dan Osipov]

I think I've seen the conversation before - tt_news queries run checks 
on so many columns, its counterproductive to create so many indexes... 
Right?

Also, the tt_news table has a medium blob column, which prevents using a 
n in memory table to be used in sorting, and has to resort to on disk 
temporary table.

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Dmitry Dulepov wrote:
> Hi!
> 
> Dan Osipov wrote:
>> Tried - in that case tt_news FE generation queries take significantly
>> longer. I used the values in one of your presentations for InnoDB
>> configuration setup (with slight variations).
> 
> Than you need to play with indexes. Using InnoDb will skip locks, indexes will ensure faster queries.
>