Opened 14 years ago

Closed 14 years ago

Last modified 14 years ago

#38 closed task (fixed)

Add database keys, unique constraints, etc.

Reported by: adehnert Owned by:
Priority: minor Milestone: Sometime
Component: Core Version:
Keywords: Cc:
Size: medium

Description

AthenaMoiraAccount? username, various slugs, and so forth, could probably all stand to grow unique=True or listing in unique_together. Go through the models and add that where appropriate.

Change History (4)

comment:1 Changed 14 years ago by adehnert

  • Priority changed from major to minor

comment:2 Changed 14 years ago by adehnert

  • Component changed from Default to Core
  • Size set to medium

comment:3 Changed 14 years ago by adehnert

  • Resolution set to fixed
  • Status changed from new to closed

Fixed:

commit a03cb616a09e2557044ec5204cfee5703d878332
Author: Alex Dehnert <adehnert@mit.edu>
Date:   Fri Apr 6 01:28:28 2012 -0400

    Add indices to database tables
    
    Fixes ASA Trac #38. Also, makes space-related scripts quick instead of
    stupidly slow...

comment:4 Changed 14 years ago by adehnert

"Stupidly slow", for the curious, here means that the query to load people data was taking ~550 seconds, and now the whole script takes about 1.7 seconds.

Note: See TracTickets for help on using tickets.