Juniper - Add indexes to improve searching speed of polines

Description

Purpose/Overview:
In order to speedup searching of polines via GET /orders/order-lines database indexes should be added.

Following warnings found in logs:

Acceptance criteria:

  • Indexes added

  • No warnings present while invoking following requests:

Environment

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Ann-Marie Breaux November 25, 2021 at 7:28 AM

Hi I think this helped, but I think we'll need MODINVOICE-333 also to get Juniper completely working.

Tested on Juniper Bugfest (even though MODINVOICE-333 is not yet released)

  • TAMU file (18 invoices, 1104 invoice lines) completed just fine. Woohoo!

  • Chicago file (9 invoices, 1326 invoice lines) completed with errors

I'll go ahead and close this issue, since I think it definitely has helped the situation.

Oleksii Petrenko November 23, 2021 at 12:40 PM

 Module deployed to Juniper BF. Please proceed with verification

Damien November 19, 2021 at 7:22 PM

  Sorry, I don't think I will have the time to do that today.

Ann-Marie Breaux November 19, 2021 at 7:16 PM

Hi Do you think we can make this release for Juniper HF 4 today (Friday)? () If possible, that would be really helpful.

cc:

Ann-Marie Breaux November 19, 2021 at 6:52 PM

Conversation on about whether to include this in Juniper or not. After MODINVOICE-318 was merged and tested in Juniper BF, large invoice file still didn't load. Discussed with Thunderjet and decided to add this to Juniper HF4, to see if it will help.
Data Import fix approved by CPT on Slack release_bug_triage channel 21 Sept 2021 (MODDICORE-177). Since it appears to be an Acq problem instead (MODINVOICE-318), and the MODINVOICE change needs this MODORDSTOR change to be more performant, copying that approval to this Jira.

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Thunderjet

Fix versions

Release

R2 2021 Hot Fix #4

CSP Approved

Yes

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created November 19, 2021 at 2:36 PM
Updated January 26, 2022 at 2:50 PM
Resolved November 22, 2021 at 3:49 PM
TestRail: Cases
TestRail: Runs