On 10-11-11 11:12, Victor Livakovsky wrote:
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.
If these queries are really produced by the core I seriously doubt that
they know what they are doing (sorry, I don't mean to offend anybody,
but the example query really sucks.
It does however explain why uncached TYPO3 pages are so terrible slow..
It's no problem to use LIKE, but if you are using LIKE with a wildcard
at the beginning (LIKE '%,0') MySql is unable to use the index.
http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html
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.
In my humble opinion LIKE '%,0' is a much bigger problem it shouldn't be
used.
To speed up the site you could install the extension 'cachemgm' and set
a scheduler to cache the pages automatically at night.
--
Kind regards,
Muriel le Pair
_______________________________________________
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
