Re: Subqueries or Joins? Problems with multiple table query

[Stefan Schwarzer <stefan.schwarzer@xxxxxxxxxxxx>]

> > > > > Select countries.name, basel.year, basel.value, cites.year,  
> > > > > cites.value
> > > > > From countries
> > > > > Left Join basel on basel.id_country = countries.id_country and
> > > > > basel.value=1
> > > > > Left Join cites on cites.id_country = countries.id_country and
> > > > > cites.value=1
> > > >
> > > > I would have thought so, but the query turns forever.
> > >
> > > How many rows in each of your tables, and what indexes do you have?
> >
> > around 5000 rows
>
> It takes a long time for just 5000 rows?  Could you provide the
> execution plan for it by putting EXPLAIN ANALYZE at the front of your
> query and post the result here?

Ok, seems to be a problem with the server and a running process or so.  
On my local machine: great! Works fine. Thanks a lot for your help!

<<attachment: smime.p7s>>