MySQL Forums
Forum List  »  Partitioning

Re: Can you Partition BETWEEN 2 fields?
Posted by: wes mahler
Date: January 04, 2008 04:36AM

Nevermind I got it!

I went ahead and partitioned the ipfrom field.

so when I selected I just do.

SELECT id FROM xxx WHERE ipfrom >= 1135173476 AND ipfrom <= 1135173476 AND ipto <= 1135173476


And it uses the partitions like magic, SUPER quick now.

Options: ReplyQuote

Written By
January 04, 2008 04:24AM
Re: Can you Partition BETWEEN 2 fields?
January 04, 2008 04:36AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.