design q on global variables vs local variables

[gacaccia]

hi all,

just wondering what thoughts might be out there on this. i have a page with a recordset variable that is used in two different procedures on the page and as part of the main code also. for example...

<%
...
rsVariable.open strSQL, objConn
...

sub sub1()
...
rs.Variable.open strSQL, objConn
...
end sub

sub sub2
...
rs.Variable.open strSQL, objConn
...
end sub
%>

in a situation like this, where the recordset variable is being used to return a new record set in each instance, is it better to have one global recordset variable and directly reference it in each procedure, or is it better to create a local recordset variable for each of the procedures? does it matter?

glenn