Join takes way too long. How to optimize this smal query?

2002-05-20 Thread andy
Hi there, after reading a nice articel on normalisation, I did split my tables and now I am suffering performance lost. this query (finding out the amount of user which have posted an article on germany) takes 4.5 s: SELECT count(DISTINCT user_recommending) FROM recommendations t INNER JOIN

Re: Join takes way too long. How to optimize this smal query?

2002-05-20 Thread Gelu Gogancea
[EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 20, 2002 1:48 PM Subject: Join takes way too long. How to optimize this smal query? Hi there, after reading a nice articel on normalisation, I did split my tables and now I am suffering performance lost. this query (finding out