[Building Sakai] Duplicate Unique Keys on mfr_area_t
Mike Jennings
mike_jennings at unc.edu
Mon Jan 30 16:41:41 PST 2012
Sam, I will also check the other tables in MSGCNTR as it appears that
there might be others out there is the same issue. I will put them all
under the same jira.
Mike
On 1/30/2012 7:38 PM, Sam Ottenhoff wrote:
> 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
> <mailto: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 <mailto:mike_jennings at unc.edu>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> <mailto: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
> <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
> subject of "unsubscribe"
>
>
--
==============================================================================
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
More information about the sakai-dev
mailing list