Company: Link Technologies
Case No: L12309. Project: 12.44: LinkSOFT Version 12.44
Logged By: Sanjay (Link Technologies) on 06 Jul 2021 04:48PM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 36.00 (Weight: 40.00)
Version: 12.44.0709
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Rashna, Sanjay, Vineet
Resolve By: Friday, 09 July 2021 11:59 PM [1025 days since logged date]
Status: Closed
Subject: Reports Performance Improvements
Summary:    

Review all reports and perform Performance checks with particular note to:

  1. Reasonable date range for sales reports
  2. Reasonable data set for the report to render ~100,000 max
  3. Cleanup links using indexed columns only
  4. Use IN as opposed to NOT IN
  5. Filter all tables correctly

Complete the table below. Add one comment for each report updated

Table 1 - Reports changed for performance - Verify on Nayans HQ DB and site files on LinkQA4.

NoReport NameDetails (Expected time) for data generated between 01/01/2021 to 31/01/2021StatusReport Date - 01/01/2021 to 31/01/2021
1Sales Summary/Detail Report

Procedure execution: 1m 18s
Report rendering: ~5m.
Pages: 3685

 Pass
Time: 9 Mins and 2 Seconds
Pages: 3685
2Debit / Credit Note Listing

Procedure execution: < 1s
Report rendering: < 1s
Pages: No data in report

 Pass
Time: <1 second
Pages: No Data
3Deleted Items ReportProcedure execution: 30s
Report rendering: ~1m.
Pages: 117
 Pass
Time: 31 seconds
Pages: 117
4Order Payment Audit ReportProcedure execution: 20s
Report rendering: ~1m
Pages: 2690
 Pass
Time: 4 Mins and 50 Seconds
Pages: 2690
5Outstanding Layby & Credit TransactionsProcedure execution: 12s
Report rendering: ~1m
Pages: 653
 Pass
Time: 1 Min and 38 Seconds
Pages: 653
6Park Transaction Audit ReportProcedure execution: < 1s
Report rendering: < 1s
Pages: No data in report
 Pass
Time: <1 Second
Pages: 1
7Payment Allocation Report
Procedure execution: 1m 40s
Report rendering: ~3m
Pages: 4231
 Pass
Time: 8 Min and 38 Seconds
Pages: 4231
8Payment Detail ReportProcedure execution: 1m 37s
Report rendering:~2m
Pages: 2105		 PassTime: 7 Min and 41 Seconds
Pages: 4231
9Payment Surcharge ReportProcedure execution: < 1s
Report rendering: < 1s
Pages: 2
 Pass
Time: 8 Seconds
Pages: 2
10Returns ReportProcedure execution: 1s
Report rendering: 1s
Pages: 15		 Pass
Time: 9 Seconds
Pages: 15
11
Sales Analysis
Procedure execution: 1m
Report rendering: 1m
Pages: 167
Pass
Time: 1 Min and 38 Seconds
Pages: 167
12
Sales by Customer
Procedure execution: 4m 10s
Report rendering: 5m
Pages: 3092
Pass
Time: 8 Min and 34 Seconds
Pages: 3092
13
Sales by Location Comparison
Procedure execution: 21s
Report rendering: <1m
Pages: 408
Pass
Time: 56 Seconds
Pages: 408
14
Sales by Machine
Procedure execution: 1m 25s
Report rendering: <2m
Pages: 2728
Pass
Time: 8 Mins 12 Seconds
Pages: 2909
15
Sales by Salesperson
Procedure execution: 1m 13s
Report rendering: <3m
Pages: 2419
Pass
Time: 6 Mins 11 Seconds
Pages: 2909
16
Sales by Week Ending
Procedure execution: 42s
Report rendering: <3m
Pages: 75
Pass
Week Ending Date - 31/01/2021
Time:2 Mins 04 Seconds
Pages: 72
Audit Notes:Edited by rashna on 14/07/21 10:05. Edited by rashna on 13/07/21 15:09. Edited by rashna on 13/07/21 14:59. Edited by rashna on 13/07/21 14:49. Edited by rashna on 13/07/21 14:30. Edited by rashna on 13/07/21 14:27. Edited by rashna on 13/07/21 14:21. Edited by rashna on 13/07/21 14:13. Edited by rashna on 13/07/21 14:09. Edited by rashna on 13/07/21 13:52. Edited by rashna on 13/07/21 13:12. Edited by rashna on 13/07/21 13:11. Edited by sanjay on 12/07/21 16:42. Edited by alvis on 12/07/21 15:56. Edited by alvis on 12/07/21 15:56. Edited by alvis on 09/07/21 14:43. Edited by sanjay on 09/07/21 11:18. Edited by sanjay on 09/07/21 11:02. Edited by alvis on 09/07/21 10:32. Edited by sanjay on 09/07/21 08:12. Edited by alvis on 07/07/21 16:43. Edited by alvis on 07/07/21 16:01. Edited by alvis on 07/07/21 14:14. Edited by alvis on 07/07/21 13:10. Edited by alvis on 07/07/21 11:57. Edited by alvis on 07/07/21 11:44. Edited by alvis on 07/07/21 09:47. Edited by alvis on 07/07/21 09:42. Edited by alvis on 07/07/21 09:26. Edited by alvis on 07/07/21 09:11. Edited by alvis on 06/07/21 16:48. Edited by sanjay on 06/07/21 16:44. Edited by sanjay on 06/07/21 16:42. 
06 Jul 202104:49PM Comment 1 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-07-2021 08:48 PM Time Taken: 0.50
Sales Summary/Detail Report refactored

09 Jul 202108:12AM Comment 2 by Sanjay (Link Technologies) Case L12309 added to project 12.44
09 Jul 202111:19AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-07-2021 03:18 PM Time Taken: 30.00
Proceed with UAT

12 Jul 202103:56PM Comment 4 by Alvis (Link Technologies) ETC was changed from 09/07/2021 to 09/07/2021
13 Jul 202101:40PM Comment 5 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-07-2021 11:53 AM Time Taken: 3.00
Part A - System Test/UAT Results
1. Developer comments are complete and accurate(Yes/No):
2. Complete Table 1 below:

Table 1 - Test Results

Table 1 - Reports changed for performance - Verify on Nayans HQ DB and site files on LinkQA4.



01/01/2021 - 01/01/2021
day
01/01/2021 - 07/01/2021
week
01/01/2021 - 31/01/2021
month

NoReport NameTime Taken
Pages
Time Taken
Pages
Time Taken
Pages
Status
1Sales Summary/Detail Report30s
161
60s
838
7m
3685
pass
2Debit / Credit Note Listing1sno data
 1s
no data
1s
no data
pass
3Deleted Items Report30s6
 50s
261m
117
pass
4Order Payment Audit Report15s
118
 1m
612
5m
2690
pass
5Outstanding Layby & Credit Transactions2m
658
 



pass
6Park Transaction Audit Report1s
no data
 1sno data
1s
no data
pass
7Payment Allocation Report
1m
185
 2m962
8m
4231
pass
8Payment Detail Report20s92
 2m479
8m
2105
pass
9Payment Surcharge Report1s
1
 1s1
10s
2
pass
10Returns Report1s2
 4s
4
5s
15
pass
11
Sales Analysis
20s
56
1m
108
2m
167
pass
12
Sales by Customer
1m
135
3m
703
9m
3092
pass
13
Sales by Location Comparison
10s
150
30s
265
1m
408
pass
14
Sales by Machine25s
128
2m
662
8m
2909
pass
15
Sales by Salesperson
30s
107
2m
551
6m
2419
pass
16
Sales by Week Ending
2m
73




pass

Environment Details
1. Application version: 12.43.0712
3. Setup: LinkQA4
4. Server: LinkQA4
5. Database: CLIENT-NAYANS-HQ-LINKSOFT

Part B: Next Step: UAT


14 Jul 202110:07AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-07-2021 02:05 PM Time Taken: 1.50

Hi Sanjay, 

The call header has been updated with the test results,

Test Environment

  1. URL - http://10.0.0.14/CLIENT-NAYANS-HQ-LINKSOFT
  2. Version - 12.44.0713GA

Next Step - Closure

Thanks
Rashna



14 Jul 202101:41PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 14-07-2021 05:41 PM Time Taken: 1.00
Thanks Rashna

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

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