; bytes shorter and each disk i/o and can read/buffer more
index rows that table rows in the same size disk 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
l Message-
From: Michael Stassen [mailto:[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 uncle
lto:[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
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
ergio Salvi
Cc: 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
&
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|
lto:[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
ha
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) | | MU
