Hello,
I found that an index is missing from upgrading procedures in
schema.tpl of comment module.
Although it is adding publishStatus column, there is no query
to add index for that column.
When "creating" from scratch, the table has the index.
http://fisheye3.atlassian.com/browse/gallery/branches/BRANCH_2_3/gallery2/modules/core/classes/GalleryStorage/schema.tpl?r=18194
20 ALTER TABLE DB_TABLE_PREFIXComment
21 ADD COLUMN DB_COLUMN_PREFIXpublishStatus int(11) NOT NULL DEFAULT '0';
Thus, I was suffering from fatal performance degradation.
I don't know whether this is reported or not. Sorry if it's a duplicate.
Posts: 27300
Please file a bug:
http://sourceforge.net/tracker/?atid=107130&group_id=7130&func=browse
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team