Re: replace subquery with left join

From: Moritz Franckenstein <maf-soft_at_gmx.net>
Date: Wed, 6 Nov 2002 17:59:25 +0100
Message-ID: <aqbhql$8j7gv$1@ID-19882.news.dfncis.de>

Hans Sieghart <Hans.Sieghart_at_frischeis.at.nospam> wrote:
> Hello everybody
>
> I've tested all solutions.

did you really try my solution? was it wrong?

> It's awfully slow:
> There are about 24000 records in the items-table and about
> 170000 records in the prices-table and a query lasts circa
> 50 min!

of course, you need good indices (or indexes?)... this amount of data should normally be no problem.

--
Moritz Franckenstein
mailto:maf-soft_at_gmx.net
http://www.maf-soft.de/
icq: 22030984  y!: maf_soft

Received on Wed Nov 06 2002 - 10:59:25 CST