:[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
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 are comparing
read.
My free humble opinion,
Ed
-Original Message-
From: MerchantSense [mailto:[EMAIL PROTECTED]
Sent: Friday, June 25, 2004 10:56 AM
To: [EMAIL PROTECTED]
Subject: Why won't mysql use the index? WAS: strange table speed issue
This is crazy. If someone can help me out, I'll pay them
Hi - I need some help :)
I set up a simple mysql table:
mysql describe ip2org;
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| ip_start | bigint(20) | |
:[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
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|
: 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
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