On 10 Jun 2002, at 17:10, Elsad YUSIFLI wrote:
> WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%')
What are you trying to accomplish there? '%' is not a special
character in regular expressions. Are you mixing up REGEXP and LIKE?
Even if that's what it is, I'd expect a column called ip to be a
com
Try using LIKE instead of regexp and create index on HOST_NAME if not
present.
Nilesh
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 1:24 PM
To: Elsad YUSIFLI; [EMAIL PROTECTED]
Subject: Re: 45 seconds
I have multiple tables on a 166MMX
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
--
Hello,
The reason that it takes so long is because you are using regexp on a
function to join the table. That means that MySQL can't use indexes for
that column. If you run an EXPLAIN on the query you will see that is
true.
To speed up the query some you could add an index on
new_raw_log(G
Check that your fields are indexed.
This usually fixes it.
George
- Original Message -
From: "Elsad YUSIFLI" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 3:10 PM
Subject: 45 seconds
>
> i have a table and 51000 records in it.
> it has got an index on HOST_NAM
