Company: Link Technologies
Case No: L11957. Project: 12.10: LinkSOFT version 12.1
Logged By: Alvis (Link Technologies) on 28 Apr 2020 04:55PM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 9.00 (Weight: 9.00)
Version: 12.10.1020
Assigned To: Development
Circulation: Alvis, Development
Resolve By: Friday, 01 May 2020 12:00 AM [1668 days since logged date]
Status: Closed
Subject: Review indexes and fine-tune for performance improvement
Summary:    

Some indexes are a significant portion of the data storage and are causing memory issues.

Review indexes and fine-tune for performance improvement.

Audit Notes:
01 May 202004:57PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 01-05-2020 08:52 PM Time Taken: 8.00

Development work for this case has been completed.

The change will be available in version: 11.5.0501

1. The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Removed duplicate indexes from POS Order tables
  2. Refactored indexes for POS Order tables. Index size has reduced from 13GB to 5GB in a large database.
  3. Fine-tuned report (Customer Fleet Transaction Listing) to use indexed columns when extracting information from POS Order table

2. Affected Areas:

  1. Database index size. Verify using SSMS (Disk usage report)
  2. Customer Fleet Transaction Listing

3. The issue was caused by:

  1. Improvement

4. Notes: 
5. Next Step: UAT


04 May 202001:44PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 04-05-2020 05:42 PM Time Taken: 1.00
LBS has tested the changes to Customer Fleet Transaction Listing on OTGL database and has advised that it is working as expected.

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11957 in the subject line of all emails regarding this issue.

Document size: 3.0 KB
For call complaints, please contact the Managing Director of the company using this form.