j'avais déjà posé la question et je la repose car ce problème va probablement tuer notre site si nous ne trouvons pas la solution.
Déjà les versions :
Xoops 2.0.16
News 1.56
La base : 18 639 articles dans News, 14 191 commentaires
Le siteLa requête appelée une à deux fois par minutes :
SELECT s.*, t.* FROM xb2460_stories s, xb2460_topics t
WHERE (s.published > 0 AND s.published <= 1231178382)
AND (s.expired = 0 OR s.expired > 1231178382)
AND (s.topicid=t.topic_id)
AND s.topicid IN (408,470,452,106,490,451,443,425,333,423,422,421,420,274,458,158,107,124,415,240,230,479,110,468,244,377,105,34,156,121,142,82,427,234,225,170,111,253,436,9,282,46,287,489,193,249,303,325,189,393,268,113,174,245,314,165,118,159,149,91,462,128,398,187,203,153,246,210,344,320,157,319,259,227,215,286,345,77,242,372,299,324,329,257,407,406,173,302,370,403,341,72,338,400,267,264,263,256,222,176,119,351,394,220,223,183,182,409,54,81,217,212,209,216,221,397,413,431,254,416,359,237,301,342,226,205,477,419,169,122,112,453,143,480,445,293,294,184,378,218,271,208,41,414,364,5,357,117,94,288,214,280,473,285,166,163,300,290,411,482,211,496,483,281,291,485,321,429,430,262,206,362,493,309,494,434,495,178,266,132,87,80)
AND s.ihome=0
ORDER BY s.published DESC;
Info de mysql-slow-log : # Query_time: 10 Lock_time: 0 Rows_sent: 30 Rows_examined: 36680
j'ai essayé de pister dans le code les endroits où cette requête est appelé et on essayé de faire en sorte qu'elle ne soit pas affichée, mais nada, toujours là.
Une aide serait appréciée de la part de la communauté xoops...