Release 27th June 2021 - Maintenance Tasks

Summary:
Scaled up Production databases from 750GB to 1TB

Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3485

Detail:
The SQL Production databases in both West Europe and North Europe have been scaled up to support a max data size of 1TB.

Summary:
Removed Bespoke Ecom Cross Dock functionality for Brand Alley

Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3357

Detail:
Removed all references to “Ecom Cross Dock” as this is no longer used. This was bespoke functionality for the client “Brand Alley” and is no longer required.

Summary:
Improved system performance by refactoring the Query that returns Products for a Supplier on the front end when receiving stock.

Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3492

Detail:
Some clients like SilkFred have over 620 000 products and this number is increasing each day. The query that returns Products for a Supplier was refactored to better handle large volumes of products.

Summary:
Improved system performance by refactoring the Query that returns Locations for a Licence Plate on the front end when putting stock away.

Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3493

Detail:
Application Insights revealed that this query was called a number of times each day. It has been refactored to better handle the large number of requests.

Summary:
Add Database Index for OrderDocumentIdentifier table

Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3519

Detail:
The “OrderDocumentIdentifier” table gets populated when a client loads a Sales Orders and sets a “DocumentIdentifier”.

This allows clients to specify what document templates to use for each order / dispatch.

This table has increased in size over time and required a new index to improve the speed of data retrieval operations.

Summary:
Improved system performance by only retrieving the latest data for push services.

Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3496

Detail:
We push a data to clients based on various status changes.

To improve performance, we updated the Web Job in Azure to only retrieve the latest data for these push services (last 3 days).

Summary:
Refactored "IsSystemAdministrator" method

Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3537

Detail:
Application Insights identified the "IsSystemAdministrator" method is called a number of times each day. This is used to check if the user can perform administrative tasks on the system. This method was refactored to be more lightweight with better performance.