tag index missing from SOCIALEVENTTAG table
-------------------------------------------
Key: OLIO-150
URL: https://issues.apache.org/jira/browse/OLIO-150
Project: Olio
Issue Type: Bug
Components: java-app
Environment: Suse Linux Enterprise 11
Glassfish 2.1
Mysql 5.0
Reporter: James Zubb
Assignee: Shanti Subramanyam
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);
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
