[OLIO-150] tag index missing from SOCIALEVENTTAG table

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.3
• Component/s: java-app
• Environment: Suse Linux Enterprise 11; Glassfish 2.1; Mysql 5.0
• Assignee: Shanti Subramanyam
• Reporter: James Zubb
• Created: 15/Jul/10 23:43
• Updated: 28/Jul/10 03:44
• Resolved: 28/Jul/10 03:44

Description

The SOCIALEVETTAG table needs an index for the tag row. It is missing from the Java schema, but it is in the PHP schema. Not sure about Rails

This causes heavy load on mysql with many SOCIALEVENTTAG table scans.

Need to add the following to the schema.sql (copied from PHP schema.sql):

CREATE INDEX SOCIALEVENTTAG_TAG on SOCIALEVENTTAG (tag);