Our POS is very good overall but there is one utility that is very painful to use. One particular weekly EDI price update, takes 26 minutes to load, This is after the EDI data has been already downloaded and stored in the DB. We'll I finally wrote my own app to replace that and wow my app can do the same thing in 20ms.
It's a local MS SQL Server database with Gigabit Ethernet.
Any speculation what the app could possibly be doing that could take 26 minutes of 'Not Responding'? This seems to be 'off the charts' for bad performance.