| Subject: | "Invoice View" and "Shift Management" forms times out in databases with very large volume of POS Transactions |
| Summary: | Invoice View and Shift Management form times out in databases with a very large volume of POS Transactions Example - On The Go database has over 44 Million POS transactions |
| Audit Notes: | Edited by sanjay on 26/05/23 09:10. Edited by sanjay on 23/05/23 13:34. Edited by sanjay on 23/05/23 13:33. Edited by sanjay on 23/05/23 13:32. |
| 16 May 2023 | 01:08PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-05-2023 07:03 PM Time Taken: 5.00 |
| Investigations showed the following: - Shift Management Form. This form loads all shifts in the selected date Range, as well as any shift that is currently OPEN or on HOLD.
- In the OTGL database, there were over 150 open shifts dating back to 2020. This is causing a timeout issue as each shift shown on the screen requires the "Payment Summary" to be displayed.
- To correct the issue:
- Close all OLD shifts. If they are on HOLD or OPEN, the system will need to show these and calculate all the numbers.
- We have reduced the default date range to 1 week
- Invoice View. This form loads all transactions on the date range, which defaults to TODAY.
- The date range filter is causing an issue on very large databases, so the following changes have been made:
- Remove the date range filter
- Show the top 1000 rows when there is no filter
- Show the TOP N rows when a filter is selected
|
|
| 25 May 2023 | 04:14PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-06-2023 03:15 PM Time Taken: 4.00 |
| Hi Vineet, I have added a utility script that you can use to close "Open" and "Hold" shifts before a certain date. For example, to close all OPEN/Hold shifts before 01/05/2023 use this script: EXEC dbo.LT_POS_UTILITY_CloseShiftBeforeDate @Username = 'linkadmin', @Password = 'Infotech0410', @Beforeopentime = '2023/05/01' |
|
| 25 May 2023 | 04:19PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-06-2023 04:14 PM Time Taken: 7.00 Notes: ETC extended from: 16/05/2023 to 02/06/2023 |
|
The following tests were performed:
Test Setup Instructions: - Use OTGL setup to verify Performance
- Run "Close Shift Utility" to close all shifts before 01/05/2023
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Open Shift Management Form
| It opens in under 3 seconds
| Pass |
| | 2 | Open Invoice Form
| It opens in under 3 seconds
| Pass
|
| | 3 |
|
|
|
|
Important Note: Shift form does a lot of computations to determine payment values. We need to keep the shift open for less than 1 week. I cannot see a reason for keeping shifts open for longer than this time. If you need to keep shifts open for more than 2 days, please create a new case with the business case to explain why this is required so we can come up with a solution.
Environment Details - OS version: Win11
- Application version: 14.80
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|