Recordset Question

Results 1 to 2 of 2

Thread: Recordset Question

  1. #1
    Join Date
    Dec 1969

    Default Recordset Question

    When you need to access a database multiple times in the same script is it more effecient to create the recordset object each time or repeatedly open and close an existing recordset object?<BR><BR>I appreciate the help :)

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset Question

    It is *mildly* more efficient to use the same RecordSet object multiple times.<BR><BR>NOTE: Do *not* be fooled by the difference between a RecordSet object and a *reference* to one!<BR><BR>If, for example, you use ADODB.Connection.Execute to produce a RecordSet, then a new object is created each time, regardless of what you do in your VBS code.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts