<div>
Inserting the 500 rows is faster?
</div>


<div>
I suspect you will find that is the case.
</div>


I suspect you will find that is the case.

<div>
<div class="content wysiwyg-content">
I have a form which contains 500 rows of data (with 500 check boxes.) &nbsp;The user selects 200 of the 500 choices and submits the form... my question is: what is the most efficient way to handle this update? &nbsp;Do I have the action page loop through each of the 500 form variables and perform 500 update queries on my db? &nbsp;Or do I have have the web page create two in-statements and execute 2 big update queries.. ie: &nbsp;Update field where otherfield in('formvariable1','formva<wbr />riable2', etc..) &nbsp;Or is there a better way?<br />
<br />
Thansk,<br />
Chris
</div>
</div>


I have a form which contains 500 rows of data (with 500 check boxes.)  The user selects 200 of the 500 choices and submits the form... my question is: what is the most efficient way to handle this update?  Do I have the action page loop through each of the 500 form variables and perform 500 update queries on my db?  Or do I have have the web page create two in-statements and execute 2 big update queries.. ie:  Update field where otherfield in('formvariable1','formvariable2', etc..)  Or is there a better way?

Thansk,
Chris

ASP - SQL Server mass update

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.