| Subject: | LinkSOFT POS Transactions to Jiwa Sales Orders is slow |
| Summary: | Jiwa Integration is slow when configured with Linksoft. An investigation carried out showed the following results: - LinkSOFT sends orders to JIWA API at 1 every 10 seconds.
- JIWA API takes up to 2 minutes to process 1 order with 5 lines.
Client JIWA DB is 40 GB, LinkSOFT DB is 30 GB. Client DB is on QA4. |
| Audit Notes: | Edited by sanjay on 03/10/23 10:51. Edited by sanjay on 25/09/23 17:52. Edited by sanjay on 25/09/23 17:49. |
| 25 Sep 2023 | 05:52PM Comment 1 by Sanjay (Link Technologies) Case L12953 added to project 15.00 |
| 26 Sep 2023 | 12:15PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-09-2023 04:12 PM Time Taken: 12.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in versions: 15.00 and 14.90 PATCH 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Added Index on Jiwa Integration Scripts
3. Affected Areas: - Jiwa Sales Order Integration
4. The issue was caused by: - Poor Server Configuration
- Large volume data in JIWA with insufficient Server Hardware
- Recommend Server OD, Database DATA File and Database LOG Files be placed on separate SSD DISK SEGMENTS
- Setup JIWA to Re-Index and Re-Organise indexes nightly with a 10% fragmentation limit
- Jiwa Database Index Fragmentation
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 26 Sep 2023 | 04:34PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-09-2023 07:29 PM Time Taken: 8.00 |
|
The following tests were performed:
Test Setup Instructions: - Upgrade Client environment with LinkSOFT and JIWA integration. Choose a client with a very large DB and Limited Hardware Resources
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Upgrade to 15.00 and send Sales Orders across to JIWA
| Mesure Sales Order Throughput and verify it is under 10 seconds per order
| Pass
| See Event Log - average time is 4.5 seconds
|
Environment Details - OS version: Win11
- Application version: 15.00
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Figure 1 - Event log for Sales Order throughput
Next Step: Closure
|
|
| 03 Oct 2023 | 10:49AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 05-10-2023 02:41 PM Time Taken: 1.00 Notes: ETC extended from: 25/09/2023 to 05/10/2023 |
| Below is the Index that should be created in JIWA Database version 7.X **** Start Of Script
IF (EXISTS(SELECT * FROM sys.objects WHERE [object_id] = OBJECT_ID(N'[dbo].[IN_SOH]') AND [type]='U')) AND NOT (EXISTS (SELECT * FROM sys.indexes WHERE [name]=N'IX_LT_IN_SOH_QuantityLeft' AND [object_id]=OBJECT_ID(N'[dbo].[IN_SOH]'))) CREATE NONCLUSTERED INDEX [IX_LT_IN_SOH_QuantityLeft] ON [dbo].[IN_SOH] ([InventoryID], [IN_LogicalID], [QuantityLeft]) INCLUDE ([DateIn], [LCostIn], [ExpiryDate]) ON [PRIMARY] GO *** End Of Script |
|