API Slow After Upgrade from 10.2 to Kinetic 2023.2.13

[LeeB (Lee Burns)]

I have a nightly script that runs on a web server that pulls a list of Invoiced Shipments through the BAQSVC, and performs some data extraction.

Prior to our upgrade from OnPrem 10.2 to OnPrem Kinetic 2023.2.13, I had a timeout that killed this script after 480 seconds, which was more than enough time to process Shipments on our busiest day of the year (could reach to over 300 shipments)

Since upgrading, 480 seconds is enough time to allow 68-70 shipments to be processed. The entire system has felt really sluggish since the upgrade, even though our hardware analysis prior to upgrade passed the prescribed thresholds.

Where would you start looking under the hood at why things might be so slow? We hired a third party to manage our upgrade, and some things were missed (like Database Compatibility Level), so I wonder if anyone has any thoughts on the matter.

[Mark_Wonsil]

Hey Lee,

Have you seen this thread?

2023.1.X Update Post Mortem and PSA Regarding Performance (and how to fix it)

So Monday of last week we went live with a jump from 2021 to 2023.1.9 The upgrade process itself was fine there were some minor issues particularly around PCID where a bunch of new features were added that caused some headaches but overall it was a clean and easy upgrade. However immediately we noticed everything was running rather sluggish and we blamed SQL per usual, did some index maintenance , statistics etc and moved on with our lives. We continued to get non stop gripping and complaints …

[LeeB (Lee Burns)]

I have not. Thank you for that, I’ll read through it and see what I can find. Much appreciated

[LeeB (Lee Burns)]

It would appear compression was turned on by default with our version. I verified the config files match what was prescribed in the article. Thank you for that information.