i have a table and 51000 records in it. it has got an index on HOST_NAME field. next query lasts 45 seconds to execute... is it normal ? server is PIII 500 double cpu
SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME) as number FROM new_raw_log as a, dns as b WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%') AND a.GID=44 AND a.SID=12 GROUP BY a.HOST_NAME ORDER BY number DESC LIMIT 0,20 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php