Hello,
I have a joomla installation with more than 100.000+ articles on it.
The section of Article Manager of joomla is loading very slow ( 20sec + ) while the site is on dedicated server AND ALSO it should just show 10 articles per page.
I have activated mysql sqlo query log and this is a part of its log :
# Time: 101216 22:33:29
# User@Host: db[db] @ localhost []
# Query_time: 4.973945 Lock_time: 0.000205 Rows_sent: 10 Rows_examined: 821
use db_ar;
SET timestamp=1292526209;
SELECT a.*,cc.description as catdesc, cc.title as category_title, cc.title as cattitle,s.description as secdesc, s.title as $
FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-12-16 19:03:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-12-16 19:03:21' )
AND a.access <= 0 AND a.catid IN( 837 ) ORDER BY ordering asc LIMIT 10;
Is it unusual ? Special this part :
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-12-16 19:03:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-12-16 19:03:21' )