Hi,
Is something wrong with a sql query like this?
(SELECT commentname, count(comments.ID) as comid, 'comments' as section from
comments where commentname IN (SELECT DISTINCT commentname from comments
where id=35037 ORDER BY commentname)Group by commentname) UNION ALL (SELECT
Username, count(ID), 'questions' from questions where Username IN (SELECT
DISTINCT commentname from comments where id=35037 ORDER BY commentname)Group
by Username)
It is dead slow... almost doesnt work.. is it the query or is my DB set up
wrong? When i had records of around 500 rows it worked fine.. now i have
around 60000 rows its dead slow....Please help me...
