11 ms·
At work we have a support portal, to help customer support folks out. It relies on queries through a legacy service to a legacy DB. Increased row counts in the
by Karrot_Kream 4y ago
At work we have a support portal, to help customer support folks out. It relies on queries through a legacy service to a legacy DB. Increased row counts in the DB (ish because this isn't SQL) have caused high query latency resulting in frequent timeouts, and the legacy service that manages the queries keeps constantly timing out.
Our team owns it but management will never sign off on resources to fix it. None of the technical staff or upper management at the company uses the support portal so they don't care. Support folks don't have any way of offering feedback to us or our management in a way that threatens our careers. The result is that it never gets worked on and support continues complaining without anything ever happening. I spent my free time coming up with fixes but ran out of time to tie up loose ends. I'll be tasking an intern with doing that, so the support people can finally use the portal and not want to rip their hair out. This is what happens when you aren't forced to use a system and customer feedback has no effect on you, as is the case for most enterprise software.
Have you tried to use Puppeteer or Selenium to automate the timecard entry? That might help reduce the pain.