I have a page that requires me to create several recordsets and loop 
through them attempting to match elements and generate statistics.  Is 
there a way to "link" multiple recordsets together?

Yes, I know a little about SHAPE.

But if your JOIN is very slow then you probably need to consider what you're
indexing, or how your query is constructed. There are few things that can be
done more efficiently in ASP by scrolling through recordsets as compared to
being done in the database.

Can you post what database you're using, what your table structure is, what
the JOIN query is that is so slow etc...?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Sandi Williams" <sandi-williams@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, May 15, 2002 7:04 PM
Subject: [asp_databases] Re: Several recordsets


: The problem with that is there are several recordsets and a join times out
: or is very slow.  Do you know anything about the SHAPE command?
:
: > Do a JOIN or similar in your SQL query?
:
: Cheers
: Ken
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: "Sandi Williams" <sandi-williams@c...>
: Subject: [asp_databases] Several recordsets
:
:
: : I have a page that requires me to create several recordsets and loop
: : through them attempting to match elements and generate statistics.  Is
: : there a way to "link" multiple recordsets together?
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:

The problem with that is there are several recordsets and a join times out 
or is very slow.  Do you know anything about the SHAPE command?

> Do a JOIN or similar in your SQL query?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Sandi Williams" <sandi-williams@c...>
Subject: [asp_databases] Several recordsets


: I have a page that requires me to create several recordsets and loop 
: through them attempting to match elements and generate statistics.  Is 
: there a way to "link" multiple recordsets together?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Do a JOIN or similar in your SQL query?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Sandi Williams" <sandi-williams@c...>
Subject: [asp_databases] Several recordsets


: I have a page that requires me to create several recordsets and loop 
: through them attempting to match elements and generate statistics.  Is 
: there a way to "link" multiple recordsets together?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~