Which one is better and more effecient?

I have a program that does some pretty heavy duty calls to an Oracle database,
and it was originally written with a Single Public Resultset, that is used over
and over for about 30-50 different queries (non of them are concurrent, just
one at a time).

I was wondering if this was a better way than Dim or Static in each subroutine
instead?

Thanks in advance

DM

Remove the last s