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


Subject
Views
Written By
Posted
3841
January 04, 2008 04:24AM
Re: Can you Partition BETWEEN 2 fields?
2599
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.