[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