Topic: Recorder League Tables timing out
Is there a way of caching the recorder league table on within our websites? The current forms are trying to do it on the fly and we are getting this timeout error 90% of the times it is run:
This league table includes the records entered via the LERC Wales app and SEWBReCORD.
There was an SQL error: ERROR: canceling statement due to statement timeout - SELECT COUNT(*) FROM ( SELECT DISTINCT o.created_by_id FROM cache_occurrences_functional o JOIN users u on u.id=o.created_by_id and u.id<>1 JOIN people p on p.id=u.person_id and p.deleted=false JOIN users privacyusers ON privacyusers.id=o.created_by_id WHERE o.training=false AND (o.website_id in (41) OR privacyusers.id=1 OR privacyusers.allow_share_for_reporting=true OR privacyusers.allow_share_for_reporting IS NULL) AND o.website_id in (23,41) AND o.zero_abundance='f' AND ('142,143,511'='' OR o.survey_id in (142,143,511)) AND o.created_by_id not in (1,8764) LIMIT 42) AS subquery
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk