Just go back and preview the thread and you will see if you posted or not
Some pesky bit of SQL somewhere looping around checking something it doesn't need to
I have almost the same thing at work, each night I have to move over 1,000 orders which have up to 8 different order numbers associated to them.
All other depots just move maybe 50 orders and they move each individual order by order number and it is instant. At my depot we move everything as we are trialing new software to maximise vehicle utilisation and we have to move the actual order, this is sometimes instant and sometimes takes 3/4 minutes which if you work it out would take forever
Flagged it to IT and they said 'well use the order numbers and it will be instant' no $hit sherlock but then I will have up to 8,000 to move 'erm.... ok well we will look into it then' turns out it is an indexing problem, when you don't enter the order number the system looks through EVERY order to find corresponding ones so hopefully a quick fix
OK wake up now it was in interesting story I thought