Hi, I have a problem with my database. It alway overload, my friend tell me this queries: Its having too many queries like -- Copying to tmp table | SELECT DISTINCT DAYOFMONTH(date) as day FROM dle_post WHERE date >= '2010-10-01' AND date < '2010-10 9936393 | db1 | localhost | dbsite1 | Query | 0 | Sorting result | SELECT id, title, date, alt_name, category, flag FROM dle_post WHERE approve='1' AND date >= '2010-1 Could you help me optimize this ? Thanks so much