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_at_ID-19882.news.dfncis.de>
Date: Wed, 6 Nov 2002 17:59:25 +0100
Message-ID: <aqbhql$8j7gv$1_at_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_softReceived on Wed Nov 06 2002 - 17:59:25 CET