I'm trying to help our archivist <http://archives.library.wcsu.edu/omeka>. The browse items and browse maps are extremely slow. I've turned on the slow query log and this is what I'm getting:
# Query_time: 56 Lock_time: 0 Rows_sent: 1 Rows_examined: 66869772 SELECT COUNT(DISTINCT(tags.id)) FROM <code>omeka_tags</code> AS <code>tags</code> LEFT JOIN <code>omeka_records_tags</code> AS <code>records_tags</code> ON records_tags.tag_id = tags.id;
Look at the number of rows! There are only 2,500 item in the database, 5,542 tags and 12,065 record tags. I'm not familiar with the code base (nor php). Any hints would be appreciated.
He is running latest version of Omeka, but an old MySQL 5.0 (which I plan to update (but I don't think is the cause of the problem).
Thanks for an suggestions,