kjolley / BIGSdb

Bacterial Isolate Genome Sequence Database (BIGSdb): A platform for gene-by-gene bacterial population annotation and analysis.
https://pubmlst.org/software/bigsdb/
Other
58 stars 20 forks source link

Isolate queries that include LINcode in results table will be stalled if a cache renewal is occurring #947

Closed kjolley closed 9 months ago

kjolley commented 9 months ago

Scheme fields are calculated live, but LINcodes are determined using the scheme field cache. If this is being renewed then the query will stall until the renewal has completed, which can take a long time on a big database doing a full renewal.

The scheme field value (cgST) should be calculated live instead. This will be marginally slower, but as main results tables usually only show 25 or so records then it should not be noticeable.

kjolley commented 9 months ago

Cache renewal wasn't blocking queries. This was due to a database lock caused by testing.