Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Web
Expertise: Beginner
Dec 22, 2001



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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 = <connection string>
cmdUpdate.CommandText = <stored Procedure name>
cmdUpdate.CommandType = adcmdstoredprocedure

cmdUpdate.Execute , , adExecuteNoRecords

This runs the Update command and ensures that no recordset is created.
Safalta Chauhan
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date