← Back to team overview

mahara-contributors team mailing list archive

[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

References