Thanks so much Rob, I will try and use joins and avoid Selects within Selects ...I tried to comment out this select and it works... Gosh I wonder why mysql does not support SEubqueries.. It just hangs in the copying to tmp table status. Atleast I know whats wrong... Thanks very much
On Mon, Oct 20, 2008 at 8:06 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > 1, Subqueries should be avoid when using mysql. Rewriting to be using joins > will probably solve your problem. > 2. Explain is your friend. > > > On Mon, Oct 20, 2008 at 4:38 PM, Sangeetha <[EMAIL PROTECTED]> wrote: > >> 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... >> > > > > -- > Rob Wultsch >