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.
_______________________________________________
TYPO3-english mailing list
[email protected]
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english