I am currently writing an application that needs to insert rows into sql server once every 10th of a second..

This is causing a massive overhead on the server and without slowing the process down I am struggling to find a decent solution to the problem.

I have tried bulk inserting the rows using openXml but this causes CPU hammering whilst the XML is being parsed and inserted..

Any idea's ?