473,326 Members | 2,136 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Resource Use

MDW
Theoretical question.

If I create an recordset using the ubiquitous

Set objRS = objConn.Execute(strSQL)

I'm told that at the end of my code, I should set objRS
back to nothing to release the resources it uses. That's
all fine and good. My question is, if I create several
different recordsets throughout the course of the ASP
page, and (because I'm lazy) I want to re-use the name
objRS....should I set it to nothing before I re-create it
using a SQL statement? In other words, is there any
appreciable performance/resource difference between these
two scenarios?

' SCENARIO 1
Set objRS = objConn.Execute(strSQL)

....

Set objRS = objConn.Execute(strSQL2)
....

Set objRS = objConn.Execute(strSQL3)
....

Set objRS = objConn.Execute(strSQL4)

....

Set objRS = Nothing

' SCENARIO 2
Set objRS = objConn.Execute(strSQL)

....

Set objRS = Nothing
Set objRS = objConn.Execute(strSQL2)
....

Set objRS = Nothing
Set objRS = objConn.Execute(strSQL3)
....

Set objRS = Nothing
Set objRS = objConn.Execute(strSQL4)

....

Set objRS = Nothing

Jul 19 '05 #1
2 2321
There's nothing lazy about re-using a variable.

You only need to destroy it once at the end. It wouldn't be a bad idea to
close the recordset before opening it on another SQL statement.

Bob Barrows
PS. You should always close the recordset before setting it to nothing.
Ditto for the connection.

MDW wrote:
Theoretical question.

If I create an recordset using the ubiquitous

Set objRS = objConn.Execute(strSQL)

I'm told that at the end of my code, I should set objRS
back to nothing to release the resources it uses. That's
all fine and good. My question is, if I create several
different recordsets throughout the course of the ASP
page, and (because I'm lazy) I want to re-use the name
objRS....should I set it to nothing before I re-create it
using a SQL statement? In other words, is there any
appreciable performance/resource difference between these
two scenarios?

' SCENARIO 1
Set objRS = objConn.Execute(strSQL)

...

Set objRS = objConn.Execute(strSQL2)
...

Set objRS = objConn.Execute(strSQL3)
...

Set objRS = objConn.Execute(strSQL4)

...

Set objRS = Nothing

' SCENARIO 2
Set objRS = objConn.Execute(strSQL)

...

Set objRS = Nothing
Set objRS = objConn.Execute(strSQL2)
...

Set objRS = Nothing
Set objRS = objConn.Execute(strSQL3)
...

Set objRS = Nothing
Set objRS = objConn.Execute(strSQL4)

...

Set objRS = Nothing


Jul 19 '05 #2
MDW
Thx for the info.

-----Original Message-----
There's nothing lazy about re-using a variable.

You only need to destroy it once at the end. It wouldn't be a bad idea toclose the recordset before opening it on another SQL statement.
Bob Barrows
PS. You should always close the recordset before setting it to nothing.Ditto for the connection.

MDW wrote:
Theoretical question.

If I create an recordset using the ubiquitous

Set objRS = objConn.Execute(strSQL)

I'm told that at the end of my code, I should set objRS
back to nothing to release the resources it uses. That's
all fine and good. My question is, if I create several
different recordsets throughout the course of the ASP
page, and (because I'm lazy) I want to re-use the name
objRS....should I set it to nothing before I re-create it using a SQL statement? In other words, is there any
appreciable performance/resource difference between these two scenarios?

' SCENARIO 1
Set objRS = objConn.Execute(strSQL)

...

Set objRS = objConn.Execute(strSQL2)
...

Set objRS = objConn.Execute(strSQL3)
...

Set objRS = objConn.Execute(strSQL4)

...

Set objRS = Nothing

' SCENARIO 2
Set objRS = objConn.Execute(strSQL)

...

Set objRS = Nothing
Set objRS = objConn.Execute(strSQL2)
...

Set objRS = Nothing
Set objRS = objConn.Execute(strSQL3)
...

Set objRS = Nothing
Set objRS = objConn.Execute(strSQL4)

...

Set objRS = Nothing


.

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Danny Pressley | last post by:
I have a VS.NET 2003 Visual C++ MFC Application Project in which I added a new resource file, I then added an icon to this new resource file and did a rebuild and got the following error: "fatal...
5
by: John Perks and Sarah Mount | last post by:
When handling resources in Python, where the scope of the resource is known, there seem to be two schools of thought: (1) Explicit: f = open(fname) try: # ... finally: f.close()
5
by: Drew | last post by:
Assembly asm = Assembly.GetExecutingAssembly(); me = new Bitmap(asm.GetManifestResourceStream("me.gif")); I have used this before without any problem, but now I get: An unhandled exception...
0
by: Johann Blake | last post by:
I'm having trouble grasping how ASP.NET correctly locates resources. There is plenty of documentation on this subject but some things are not clear at all. In my ASP.NET application, I have...
7
by: craig | last post by:
....quick question for anyone who might have some experience with .net resource files in VS 2003. I have an application that is not localized, but I would still like to be able to place all of...
13
by: Bob Jones | last post by:
Here is my situation: I have an aspx file stored in a resource file. All of the C# code is written inline via <script runat="server"tags. Let's call this page B. I also have page A that contains...
2
by: WT | last post by:
Hello, Could we use 'Embedded resources' with resx files that contain text resources used in aspx pages with the syntaxe: Text="<%$ Resources:ResourcesMy,KEY1 %>" I tryed removing the...
21
by: DiAvOl | last post by:
Hello, I am using a simple php server that I wrote and have some questions related to the resource id's. When a new client connects to the server or the server opens a file the Resource id...
12
by: TS | last post by:
i have a need to possibly enable mutli language support. What benefit do i get by using a resource file instead of a custom xml solution? thanks!
0
by: CSharper | last post by:
Just curious, When you are in IDE, you are able to add a resource to the project through resource tab. Later this resource can be accessed using the resource manager. One good thing about this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.