how do i do very fast inserts to SQL Server 2008

Posted by CharlesO on Stack Overflow See other posts from Stack Overflow or by CharlesO
Published on 2010-05-18T23:43:05Z Indexed on 2010/05/18 23:50 UTC
Read the original article Hit count: 146

Filed under:
|

I have a project that involves recording data from a device directly into a sql table.

I do very little processing in code before writing to sql server (2008 express by the way)

typically i use the sqlhelper class's ExecuteNoneQuery method and pass in a stored proc name and list of parameters that the SP expects.

This is very convenient, but i need a much faster way of doing this.

Thanks.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about Performance