2 min read

How we are fixing recent performance issues in PICSWeb

Featured Image

We would like to apologise for the disruption during the last ILR submission period caused by performance issues in PICSWeb.

Since then, we have introduced a range of improvements at various points in the infrastructure. These measures are intended to increase performance and avoid similar issues occurring in the future.

The following steps have been taken so far:

  • Improved firewall configuration to not be overly aggressive reporting system unavailability

  • Introduced additional load balanced webservers

  • Tuned database server configuration

  • Tuned database load spread across database servers

  • Prevented file uploads and downloads from blocking web requests whilst waiting on eFilestore.

  • Implemented the ability for Pellcomp to abort very long running reports

  • Disabled Contact Hours to date from reports until we can make the calculation more efficient

  • Introduced detecting changes to search text in lookup lists at the server and cancelling the previous database search

  • Made use of server side session storage to cache certain user settings to avoid looking it up in the database for every page load

  • Added a record count filter to log views to prevent fetching all logs at once

  • Increased the time browsers will cache Profile pictures to 1 week to reduce calls to fetch the files so often

  • Optimised the iCal feed and reduced the window of events to 3 months from 12 months

  • Implemented limits to certain multiple record imports

  • Optimised payment imports 

  • Optimised database access in ILR Exports

  • Optimised database access in Claims calculations

  • Optimised database access in Learner Reports

  • Optimised database access for Home widgets such as Invalid Learners, Forms Management and Recent Learners

While performance has now improved, we are continuing to monitor the situation closely to spot any further issues. If you have not done so already, we recommend that you subscribe to updates from our Status Page to stay informed. Any incidents that arise in the software or our hosting service are reported here and updated when resolved.