Multiple Recordsets in a page

[Dan]

If you have multiple recordsets on a page, each of which is closed prior to
the next one being opened, is it better to use the same instantiated object
for all recordsets? I've been using separate recordsets, each named something
different, but I wonder if this uses more resources on the server.

[Sachin]

> but I wonder if this uses more resources on the server.
Yes it does
"Dan" <dan.clem@trilogynetworks.com> wrote in message
news:3b573122$1@news.devx.com...
>
> If you have multiple recordsets on a page, each of which is closed prior
to
> the next one being opened, is it better to use the same instantiated
object
> for all recordsets? I've been using separate recordsets, each named
something
> different, but I wonder if this uses more resources on the server.