List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:June 10 2002 5:24pm
Subject:Re: 45 seconds
View as plain text  
I have multiple tables on a 166MMX with 64MB ram, all containing more than
250,000 records each.... Mine takes less than 5 seconds....

I think there's something wrong at your side :-)


Kind Regards,

Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582

----- Original Message -----
From: "Elsad YUSIFLI" <elsad@stripped>
To: <mysql@stripped>
Sent: Monday, June 10, 2002 4:10 PM
Subject: 45 seconds


>
> 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 <mysql-thread111483@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-savage=savage.za.org@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
45 secondsElsad YUSIFLI10 Jun
  • Re: 45 secondsGeorge Pitcher10 Jun
  • Re: 45 secondsHarrison C. Fisk10 Jun
  • Re: 45 secondsChris Knipe10 Jun
  • Re: 45 secondsKeith C. Ivey10 Jun
RE: 45 secondsNilesh Shah10 Jun