mahara-contributors team mailing list archive
-
mahara-contributors team
-
Mailing list archive
-
Message #23263
[Bug 1407511] Re: usr_institution uses institution name as foreign key
Since we've just added an ID column to the "institution" table, it
should be fairly easy to refactor usr_institution to use that instead of
institution.name for the foreign key.
** Changed in: mahara
Milestone: None => 15.04.0
** Changed in: mahara
Status: New => Confirmed
** Changed in: mahara
Importance: Undecided => Wishlist
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1407511
Title:
usr_institution uses institution name as foreign key
Status in Mahara ePortfolio:
Confirmed
Bug description:
In current Mahara dev at the time of writing (15.04-dev), the
usr_institution table uses the institution name rather than its ID as
a foreign key. This will slow things down because it forces string
comparisons to be done instead of simple numeric value comparisons.
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1407511/+subscriptions
References