ISFDB Bibliographic Tools / Feature Requests / #424 Optimize award retrieval from the database

#424 Optimize award retrieval from the database

Status: closed

Owner: Ahasuerus

Labels: Biblio Display (48)

Priority: 5

Updated: 2013-02-09

Created: 2013-02-09

Creator: Ahasuerus

Private: No

The award retrieval function (SQLloadAwardsXBY in SQLparsing.py) currently loads all awards for a given year. However, this function is only used to load awards for one year/award combination, so it loads much more data than needed. We need to add an 'award type code" parameter to the function and make all calling scripts use it to make the loading process faster.

Discussion

Ahasuerus - 2013-02-09

Implemented in:

*common/SQLparsing.py 1.80
*biblio/awards.py 1.10
*edit/rmyearaward.py 1.6
*edit/selectyearaward.py 1.6

Installed in r2013-35 on 2012-02-08.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Ahasuerus - 2013-02-09

status: open --> closed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous

Optimize award retrieval from the database

Group

Searches

Help

#424 Optimize award retrieval from the database

Discussion