Mulitple recordset speed problem.

[Anders Tufvesson]

Hi!
I hav e solution thar loops one recordset and in the loop opens an other.
All off a sudden it is getting reeeeeeeeel slooooooow. On one server!
We have tried this on an other server with same versíons of sql-driver,
asp-driver
and mdsc-driver. No problem. We have the latest windows update.

Any one else out ther who have experinced this problem?

Thanks

Anders

[Aaron Bertrand - MVP]

> I hav e solution thar loops one recordset and in the loop opens an other.

Why are you doing that? If you show your table structure, sample data, and
desired results, someone can probably teach you how to write a join.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[Anders Tufvesson]

Tanks, but I know perfectly well how you make a join.

But that is not the problem.

The problem is why the code works excellent on one macine but
on an other machine it is slow. Same version of Sql, asp.dll, Mdac.

That is my question, not how to make a join.

Anders


"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:O96HnYB5DHA.2416@TK2MSFTNGP10.phx.gbl...

> > I hav e solution thar loops one recordset and in the loop opens an

other.

>
> Why are you doing that? If you show your table structure, sample data,

and

> desired results, someone can probably teach you how to write a join.
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>

[Aaron Bertrand - MVP]

Sorry, but we need more details. The exact same hardware? Over the exact
same network? From the exact same client machine? The exact same tables?
With the same indexes? And the same statistics? And the same peripheral /
background activity?

As asked, I don't think your question can be answered. However, one way to
speed up your page would be to get rid of this nested recordset nonsense.
If you know how to write a join, do it!

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Anders Tufvesson" <anders.tufvesson@NOSPAMtwo.se> wrote in message
news:bv5bqm$cid$1@yggdrasil.glocalnet.com...

> Tanks, but I know perfectly well how you make a join.
>
> But that is not the problem.
>
> The problem is why the code works excellent on one macine but
> on an other machine it is slow. Same version of Sql, asp.dll, Mdac.
>
> That is my question, not how to make a join.
>
> Anders
>
>
> "Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
> news:O96HnYB5DHA.2416@TK2MSFTNGP10.phx.gbl...

> > > I hav e solution thar loops one recordset and in the loop opens an

> other.

> >
> > Why are you doing that? If you show your table structure, sample data,

> and

> > desired results, someone can probably teach you how to write a join.
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > [url]http://www.aspfaq.com/[/url]
> >
> >

>
>