RE: strange table speed issue

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

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 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, t

RE: strange table speed issue

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

RE: strange table speed issue

: Thursday, June 24, 2004 10:37 PM > To: Sergio 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

Re: strange table speed issue

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'

RE: strange table speed issue

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 &

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 of a multi-field index. From the manual

RE: strange table speed issue

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|

RE: strange table speed issue

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; > +++--+--+-+---+- > +--++

RE: strange table speed issue

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

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-field index)... []s, Sergio Salvi. On Thu, 24 Jun 2004, MerchantSense wrote: > Hi - I need some help :) > > I set up a simple my