Company: Link Technologies
Case No: L12944. Project: 15.00: LinkSOFT Version 15.00
Logged By: Sanjay (Link Technologies) on 30 Aug 2023 10:30AM
Priority: Low
Product: Point of Sale
Group: Enhancement
Time Taken: 8.00 (Weight: 8.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Vineet
Resolve By: Thursday, 28 September 2023 10:38 AM [236 days since logged date]
Status: Closed
Subject: Database Performance Tuning

Customer production has the following issues:

  1. Large volume of transaction data causing performance issues when clients do not want to invest in DBA Performance Tuning

The above needs to be corrected using the following steps:

  1. Review and build automation around performance tuning
Audit Notes:Edited by sanjay on 29/09/23 14:24. Edited by sanjay on 29/09/23 14:22. Edited by sanjay on 30/08/23 10:30. Edited by sanjay on 30/08/23 10:24. 
30 Aug 202310:24AM Comment 1 by Sanjay (Link Technologies) ETC was changed from 30/08/2023 to 21/09/2023
30 Aug 202310:27AM Comment 2 by Sanjay (Link Technologies) Case L12944 added to project 15.00
18 Sep 202310:40AM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-09-2023 10:38 AM Time Taken: 1.00 Notes: Edited by sanjay on 22/09/23 16:10. Edited by sanjay on 20/09/23 10:41. ETC extended from: 21/09/2023 to 28/09/2023

Changes have been made to process SYS008 to handle Reorganise and Rebuild Indexing which will be used at OTGL to tune performance.

Please run this process after cases L12940 and L12943 are completed.

22 Sep 202304:16PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-09-2023 04:09 PM Time Taken: 7.00
The following tests were performed:

Test Setup Instructions:
  1. Setup DEMO Database
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Auto Generate 100,000 POS Orders. This will cause the Order Table Indexes to exceed 20%. Run Process SYS008 with Rule Code "SYS008.FragmentationPercent" at 1
After the process runs, index fragmentation should all be under 10%

2Enable Process "SYS004" and Archive 1ll 100,000 orders to the Archive table. This should raise Fragmentation or Orders and Archive tables to over 80%. Verify, then execute process "SYS008"
After the process runs, index fragmentation should all be under 10%

Environment Details

  1. OS version: Win11
  2. Application version: 15.00
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure

If you have any queries regarding this support incident, please email and include the Case No: L12944 in the subject line of all emails regarding this issue.

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