In one of our databases we have an orders table (Order) that has a unique ID and other order specific details. We then have a link table that links the main order to products.
On any particular order there can be up to 3000 products. The tables are part of transactional replication.
In the client application a string of product ID's is built and passed to a stored procedure, along with the orderID. The stored procedure then breaks up the string and does an insert for each one in turn.
This is slow as hell ! Can anyone help me speed it up? Any advice/help is greatly appreciated.