Menu

#130 Adding REVIEW records to a pub is very slow at approval time

v1.0 (example)
open
nobody
None
5
2018-04-03
2018-04-03
Ahasuerus
No

Adding REVIEW records to a pub is very slow at approval time. It can cause the submission approval process to itme out when a New/EditPub submission contains a lot of new reviews. We suspect that the process of linking new reviews to reviewed titles automatically is is the culprit. We need to review the SQL logic and possibly enhance it or add a new index.

Discussion

Anonymous
Anonymous

Add attachments
Cancel