[
https://issues.apache.org/jira/browse/OLIO-150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shanti Subramanyam resolved OLIO-150.
-------------------------------------
Fix Version/s: 0.3
Resolution: Fixed
Fixed as described in JIRA
> 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
> Fix For: 0.3
>
>
> 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.
