mahara-contributors team mailing list archive
-
mahara-contributors team
-
Mailing list archive
-
Message #23158
[Bug 1407511] [NEW] usr_institution uses institution name as foreign key
Public bug reported:
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.
** Affects: mahara
Importance: Undecided
Status: New
--
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:
New
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
Follow ups
-
[Bug 1407511] Re: usr_institution uses institution name as foreign key
From: Kristina Hoeppner, 2017-03-20
-
[Bug 1407511] Re: usr_institution uses institution name as foreign key
From: Robert Lyon, 2016-10-21
-
[Bug 1407511] Re: usr_institution uses institution name as foreign key
From: Robert Lyon, 2016-10-20
-
[Bug 1407511] Re: usr_institution uses institution name as foreign key
From: Aaron Wells, 2016-04-28
-
[Bug 1407511] Re: usr_institution uses institution name as foreign key
From: Aaron Wells, 2015-09-30
-
[Bug 1407511] Re: usr_institution uses institution name as foreign key
From: Aaron Wells, 2015-04-21
-
[Bug 1407511] Re: usr_institution uses institution name as foreign key
From: Robert Lyon, 2015-04-17
-
[Bug 1407511] Re: usr_institution uses institution name as foreign key
From: Aaron Wells, 2015-01-09
-
[Bug 1407511] Re: usr_institution uses institution name as foreign key
From: Aaron Wells, 2015-01-09
-
[Bug 1407511] [NEW] usr_institution uses institution name as foreign key
From: Nigel Cunningham, 2015-01-04
References