[TYPO3-english] Slow Queries From TT-News

Victor Livakovsky v-tyok at mail.ru
Thu Nov 10 11:12:42 CET 2011

Hi, Louis.

As far, as I understood, these part of queries are generated by 
enableFields() of tslib_cObj class, which comes from core, and, I believe, 
core members know, what they are doing.
Most I'm scared about "AND tt_news.pid IN(835,2905,...)" - there is really 
large number of pids. You better place all of your news records into one 
folder and set pid to it with zero recursion level.

Also you should install 'typo3profiler' extension and see, what queries are 
really slowing down your page. 

More information about the TYPO3-english mailing list