Fastest method for SQL Server inserts, updates, selects

Posted by Ian on Stack Overflow See other posts from Stack Overflow or by Ian
Published on 2010-05-19T02:10:44Z Indexed on 2010/05/19 2:50 UTC
Read the original article Hit count: 292

Filed under:
|
|
|

I use SPs and this isn't an SP vs code-behind "Build your SQL command" question. I'm looking for a high-throughput method for a backend app that handles many small transactions. I use SQLDataReader for most of the returns since forward only works in most cases for me.

I've seen it done many ways, and used most of them myself.

  1. Methods that define and accept the stored procedure parameters as parameters themselves and build using cmd.Parameters.Add (with or without specifying the DB value type and/or length)

  2. Assembling your SP params and their values into an array or hashtable, then passing to a more abstract method that parses the collection and then runs cmd.Parameters.Add

  3. Classes that represent tables, initializing the class upon need, setting the public properties that represent the table fields, and calling methods like Save, Load, etc

I'm sure there are others I've seen but can't think of at the moment as well. I'm open to all suggestions.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about ASP.NET