Don’t Create a Recordset Unless It’s Required

When running action queries make sure you add the adExecuteNoRecords option, so that a recordset is not created. You can also use this technique in lookup situations when returning just a single row with one or two fields (ID values for example). In this case a stored procedure and outparameter will be faster. Here is an example:

 Set cmdUpdate=Server.Createobject(ADODB.Command")strsql = "UPDATE Titles SET Price = Price*1.0" & "WHERE Type _= 'Business'"cmdUpdate.ActiveConnection = cmdUpdate.CommandText = cmdUpdate.CommandType = adcmdstoredprocedurecmdUpdate.Execute , , adExecuteNoRecords

This runs the Update command and ensures that no recordset is created.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: