Re: [GENERAL] Subqueries or Joins? Problems with multiple table query

[Stefan Schwarzer]

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!

smime.p7s
Description: S/MIME cryptographic signature