So, we're trying to get UPS WorldShip to work with SQL Server 2005. So here's how it looks from the user's perspective:
Put in your order number (WorldShip pulls the shipping information)
Put in the package weight (Worldship figures out the cost)
Hit OK to confirm everything and then wait 45 seconds'
Get a tracking number
Now, our shipping department sends out 100 packages a day. That little 45 second wait thing...that's an hour and a half of someone's time just waiting. So, what's going on there.
So I did a sql profiler on what was going on.
For some reason WorldShip is pulling a full...