Release 27th June 2021 - Maintenance Tasks
Module:
Database
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.
...
Module:
Outbound
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.
...
Module:
Inbound
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.
...
Module:
Inbound
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.
...
Module:
Database
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 table has increased in size over time and required a new index to improve the speed of data retrieval operations.
...
Module:
Push Web Job
Summary:
Improved system performance by only retrieving the latest data for push services.
...
To improve performance, we updated the Web Job in Azure to only retrieve the latest data for these push services (last 3 days).
...
Module:
User Management
Summary:
Refactored "IsSystemAdministrator" method
...