I'm not certain, but I don't think a multi-column index will help here. The
manual is unclear on how a multi-column index is used when you are comparing
the first key part to a range rather than to a constant, but I get the
impression it doesn't use the second key part in that case. For you,
:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 11:41 PM
To: Marc Slemko
Cc: MerchantSense; [EMAIL PROTECTED]
Subject: Re: strange table speed issue
I'm not certain, but I don't think a multi-column index will help here. The
manual is unclear on how a multi-column index is used when you
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi-field index)...
[]s,
Sergio Salvi.
On Thu, 24 Jun 2004, MerchantSense wrote:
Hi - I need some help :)
I set up a simple
:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 8:00 PM
To: MerchantSense
Cc: [EMAIL PROTECTED]
Subject: Re: strange table speed issue
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi
On Thu, 24 Jun 2004, MerchantSense wrote:
Seems ok to me...
It seems to be checking all the rows in the explain for some reason too...
mysql show index from ip2org;
+++--+--+-+---+-
+--++-+
|
I added the multicolumn, and still have the same problem :
mysql explain SELECT org from ip2org where ip_start=1094799892 and
ip_end=1094799892;
++--+---+--+-+--+-+-
---+
| table | type | possible_keys | key | key_len | ref | rows|
Sergio Salvi wrote:
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi-field index)...
MUL doesn't mean part of a multi-field index. From the manual
: MerchantSense; [EMAIL PROTECTED]
Subject: Re: strange table speed issue
Sergio Salvi wrote:
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi-field index)...
MUL doesn't mean part
On Fri, 25 Jun 2004, Michael Stassen wrote:
Sergio Salvi wrote:
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi-field index)...
MUL doesn't mean part of a
command to create this index:
alter table ip2org add index test (ip_start,ip_end);
[]s,
Salvi.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 10:37 PM
To: Sergio Salvi
Cc: MerchantSense; [EMAIL PROTECTED]
Subject: Re: strange table
Yep, that's exactly what I did
-Original Message-
From: Sergio Salvi [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 10:55 PM
To: [EMAIL PROTECTED]
Subject: RE: strange table speed issue
On Thu, 24 Jun 2004, MerchantSense wrote:
Yes, but I now have multi-column indexes
11 matches
Mail list logo