ISFDB Bibliographic Tools / Support Requests / #104 Improve the performance of Author and Series pages

Ahasuerus - 2016-07-13

Part 1 - General cleanup:

biblio/ae.py 1.14 biblio/biblio.py 1.58 biblio/ch.py 1.16 biblio/common.py 1.150 biblio/ea.py 1.20 biblio/eaw.py 1.25 common/SQLparsing.py 1.184

Installed in r2016-114 on 2016-07-13. Keeping open.
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 - 2016-07-16

Part 2 - More general cleanup:

biblio/biblio.py 1.59 biblio/common.py 1.151 common/SQLparsing.py 1.185

Installed in r2016-117 on 2016-07-16. Keeping open.
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 - 2016-07-19

Part 3 - Even more general cleanup:

biblio/biblio.py 1.61 biblio/common.py 1.153 biblio/ea.py 1.22 biblio/eaw.py 1.27 biblio/pe.py 1.39

Installed in r2016-119 on 2016-07-19. Keeping open.
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 - 2016-08-11

Part 4 - Consolidated the CGI scripts:

biblio/ae.py 1.16 biblio/biblio.py 1.63 biblio/ch.py 1.18 biblio/ea.py 1.23 biblio/eaw.py 1.28

Installed in r2016-127 on 2016-08-11. Keeping open.
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 - 2016-08-14

Part 5:

biblio/biblio.py 1.66 biblio/common.py 1.158 common/SQLparsing.py 1.192

Installed in r2016-133 on 2016-08-14. Keeping open.
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 - 2016-08-14

Part 6 - Removed the load time notifications which were accidentally released in Part 5:

biblio/biblio.py 1.67

Installed in r2016-134 on 2016-08-14. Keeping open.
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 - 2016-08-15

Part 7:

biblio/biblio.py 1.68 biblio/common.py 1.159 common/SQLparsing.py 1.193

Installed in r2016-135 on 2016-08-15.
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 - 2016-08-16

Part 8:

biblio/biblio.py 1.69 biblio/pe.py 1.40 common/SQLparsing.py 1.194

Installed in r2016-137 on 2016-08-16.
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 - 2016-08-16

Part 9 - Preload variant titles for series pages:

biblio/pe.py 1.41 common/seriesClass.py 1.16 common/SQLparsing.py 1.195

Installed in r2016-138 on 2016-08-16.
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.

Description has changed:

Diff:

--- old
+++ new
@@ -1 +1 @@
-Improve the performance of the Summary page. Currently every title's co-author and every variant title requires at least one additional database lookup, which takes a long time for authors with thousands of titles (Silverberg, Asimov, etc.) We need to pre-load author and VT information, which will greatly speed up the display process.
+Improve the performance of Author and Series pages. They need to be handled at the same time since they share much of the display logic. Currently every title's co-author and every variant title requires at least one additional database lookup, which takes a long time for authors with thousands of titles (Silverberg, Asimov, etc.) We need to pre-load author and VT information, which will speed up the display process.

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 - 2016-08-16

summary: Improve the performance of the Summary page --> Improve the performance of Author and Series pages
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 - 2016-08-16

Part 10 - Preload VTs :

biblio/pe.py 1.42 biblio/biblio.py 1.70 biblio/common.py 1.161 common/SQLparsing.py 1.196 common/library.py 1.110 common/seriesClass.py 1.17

Installed in r2016-139 on 2016-08-16.
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 - 2016-08-17

Part 11 - Pre-load single-pub title flags:

biblio/pe.py 1.43 biblio/biblio.py 1.71 biblio/common.py 1.162 common/SQLparsing.py 1.197 common/library.py 1.111 common/seriesClass.py 1.18

Installed in r216-140 on 2016-08-17.
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 - 2016-08-18

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.

Ahasuerus - 2016-08-18

Part 12 - Variant titles and transliterations performance enhancements:

biblio/pe.py 1.44 biblio/biblio.py 1.72 biblio/common.py 1.163 common/library.py 1.112 common/seriesClass.py 1.19

Installed in r2016-141 on 2016-08-18. Closing.
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.

Improve the performance of Author and Series pages

Group

Searches

Help

#104 Improve the performance of Author and Series pages

Discussion