[Building Sakai] Duplicate Unique Keys on mfr_area_t

[Sam Ottenhoff]

Duplicate unique keys will slow database inserts in the table.  Please file
a JIRA!

--Sam

On Mon, Jan 30, 2012 at 7:35 PM, Mike Jennings <mike_jennings at unc.edu>wrote:

> I was looking at the primary keys that UNC currently has running on the
> MFR_AREA_T table and found that it seems to have two unique keys on the
> table.
>
> CREATE UNIQUE INDEX CONTEXT_ID
>     ON MFR_AREA_T(CONTEXT_ID, TYPE_UUID);
>
> CREATE UNIQUE INDEX MFR_AREA_CONTEXT_UUID_UNIQUE
>     ON MFR_AREA_T(CONTEXT_ID, TYPE_UUID);
>
> Does this seem to be valid?
>
> We are currently running Sakai 2.7 with MSGCNTR 2.7.5.
>
> Based on the information here
>
>
> https://source.sakaiproject.org/svn/msgcntr/trunk/messageforums-hbm/src/sql/mysql/msgcntr_indexes_only.sql
>
> This does seem to be valid, but I just wanted to make sure that is correct.
>
> Mike Jennings
> --
>
> ==============================================================================
> Mike Jennings
> Teaching and Learning Developer
> University of North Carolina at Chapel Hill
>
> Office: (919) 843-5013
> Cell: (919) 698-3746
> E-mail: mike_jennings at unc.edu
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120130/a1b66033/attachment.html